What is the best RAID system to use in a SAN environment.
Is it ok to use RAID 5 on everything like data, log, etc
when using a SAN shared storage.In certain cases it may make sense to use other
configuration or use different raid levels for tempdb
(raid 0), log (raid 1+0), databases (raid 5) etc. Here you
have to be sure that you will be getting excellent
cooperation from the network/hardare support departments,
or if you are responsible for SAN and sql server.
Generally I would say it is ok to use raid 5 for
everything, because thats what I decided to use when we
configured SAN for sql server.
>--Original Message--
>What is the best RAID system to use in a SAN environment.
>Is it ok to use RAID 5 on everything like data, log, etc
>when using a SAN shared storage.
>.
>|||Every system has different requirements, but one is generally true - using
RAID 5 for logs is usually a bad idea because the parity calculation
requires additional overhead to read bits (disk i/o), parity calculation
(cpu, hba etc) & then the parity writes (more disk i/o).
Generally speaking, logs are far better off on a mirror, perhaps striped as
well, but not raid 5.
Regards,
Greg Linwood
SQL Server MVP
"Aboki" <waco361@.hotmail.com> wrote in message
news:13ac01c381e7$58753290$a401280a@.phx.gbl...
> What is the best RAID system to use in a SAN environment.
> Is it ok to use RAID 5 on everything like data, log, etc
> when using a SAN shared storage.
Showing posts with label system. Show all posts
Showing posts with label system. Show all posts
Friday, March 30, 2012
Wednesday, March 28, 2012
RAID FOR SQL
Hi. I've to install a server with SQL server and a RAID system. We've
installed servers
with SQL but without RAID systems. I want to know wich is the best
configuration and how many disks
to install RAID on a server wich only has to run SQL server. The RAID, must
be only for data or for
data and the operating system at time?. Thanks a lot.
> Hi. I've to install a server with SQL server and a RAID system. We've
> installed servers with SQL but without RAID systems. I want to know
> which is the best configuration and how many disks to install RAID
> on a server wich only has to run SQL server. The RAID, must be only
> for data or for data and the operating system at time ?
RAID Levels and SQL Server:
http://msdn.microsoft.com/library/en...tun_1_87jm.asp
Comparing Different Implementations of RAID Levels:
http://msdn.microsoft.com/library/en...tun_1_79pv.asp
|||JP,
The best practice I've heard and use myself is a separate volume for each of
the following:
RAID 1 volume for OS and executables
RAID 10 if possible (RAID 5 if not) for SQL Server data files
RAID 10 or at least RAID 1 for log files
RAID 10 or RAID 1 for tempdb
RAID 5 for backups
This is in general; sometimes variations are required depending on
requirements. Some SAN vendors claim their RAID 5 flavors are just as fast
as RAID 1, but I can't verify that.
Hope this helps,
Ron
Ron Talmage
SQL Server MVP
"JP" <aspento_quitar_para_correo_@.arrakis.es> wrote in message
news:OogXabz9EHA.1564@.TK2MSFTNGP09.phx.gbl...
> Hi. I've to install a server with SQL server and a RAID system. We've
> installed servers
> with SQL but without RAID systems. I want to know wich is the best
> configuration and how many disks
> to install RAID on a server wich only has to run SQL server. The RAID,
must
> be only for data or for
> data and the operating system at time?. Thanks a lot.
>
|||Please read the documentation on http://www.baarf.com/ which explains why
RAID 5 is not a performing option.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"Ron Talmage" <rtalmage@.prospice.com> wrote in message
news:%23mYi7kH%23EHA.3856@.TK2MSFTNGP10.phx.gbl...
> JP,
> The best practice I've heard and use myself is a separate volume for each
> of
> the following:
> RAID 1 volume for OS and executables
> RAID 10 if possible (RAID 5 if not) for SQL Server data files
> RAID 10 or at least RAID 1 for log files
> RAID 10 or RAID 1 for tempdb
> RAID 5 for backups
> This is in general; sometimes variations are required depending on
> requirements. Some SAN vendors claim their RAID 5 flavors are just as fast
> as RAID 1, but I can't verify that.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
>
> "JP" <aspento_quitar_para_correo_@.arrakis.es> wrote in message
> news:OogXabz9EHA.1564@.TK2MSFTNGP09.phx.gbl...
> must
>
installed servers
with SQL but without RAID systems. I want to know wich is the best
configuration and how many disks
to install RAID on a server wich only has to run SQL server. The RAID, must
be only for data or for
data and the operating system at time?. Thanks a lot.
> Hi. I've to install a server with SQL server and a RAID system. We've
> installed servers with SQL but without RAID systems. I want to know
> which is the best configuration and how many disks to install RAID
> on a server wich only has to run SQL server. The RAID, must be only
> for data or for data and the operating system at time ?
RAID Levels and SQL Server:
http://msdn.microsoft.com/library/en...tun_1_87jm.asp
Comparing Different Implementations of RAID Levels:
http://msdn.microsoft.com/library/en...tun_1_79pv.asp
|||JP,
The best practice I've heard and use myself is a separate volume for each of
the following:
RAID 1 volume for OS and executables
RAID 10 if possible (RAID 5 if not) for SQL Server data files
RAID 10 or at least RAID 1 for log files
RAID 10 or RAID 1 for tempdb
RAID 5 for backups
This is in general; sometimes variations are required depending on
requirements. Some SAN vendors claim their RAID 5 flavors are just as fast
as RAID 1, but I can't verify that.
Hope this helps,
Ron
Ron Talmage
SQL Server MVP
"JP" <aspento_quitar_para_correo_@.arrakis.es> wrote in message
news:OogXabz9EHA.1564@.TK2MSFTNGP09.phx.gbl...
> Hi. I've to install a server with SQL server and a RAID system. We've
> installed servers
> with SQL but without RAID systems. I want to know wich is the best
> configuration and how many disks
> to install RAID on a server wich only has to run SQL server. The RAID,
must
> be only for data or for
> data and the operating system at time?. Thanks a lot.
>
|||Please read the documentation on http://www.baarf.com/ which explains why
RAID 5 is not a performing option.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"Ron Talmage" <rtalmage@.prospice.com> wrote in message
news:%23mYi7kH%23EHA.3856@.TK2MSFTNGP10.phx.gbl...
> JP,
> The best practice I've heard and use myself is a separate volume for each
> of
> the following:
> RAID 1 volume for OS and executables
> RAID 10 if possible (RAID 5 if not) for SQL Server data files
> RAID 10 or at least RAID 1 for log files
> RAID 10 or RAID 1 for tempdb
> RAID 5 for backups
> This is in general; sometimes variations are required depending on
> requirements. Some SAN vendors claim their RAID 5 flavors are just as fast
> as RAID 1, but I can't verify that.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
>
> "JP" <aspento_quitar_para_correo_@.arrakis.es> wrote in message
> news:OogXabz9EHA.1564@.TK2MSFTNGP09.phx.gbl...
> must
>
RAID FOR SQL
Hi. I've to install a server with SQL server and a RAID system. We've
installed servers
with SQL but without RAID systems. I want to know wich is the best
configuration and how many disks
to install RAID on a server wich only has to run SQL server. The RAID, must
be only for data or for
data and the operating system at time?. Thanks a lot.> Hi. I've to install a server with SQL server and a RAID system. We've
> installed servers with SQL but without RAID systems. I want to know
> which is the best configuration and how many disks to install RAID
> on a server wich only has to run SQL server. The RAID, must be only
> for data or for data and the operating system at time ?
RAID Levels and SQL Server:
http://msdn.microsoft.com/library/en-us/optimsql/odp_tun_1_87jm.asp
Comparing Different Implementations of RAID Levels:
http://msdn.microsoft.com/library/en-us/optimsql/odp_tun_1_79pv.asp|||JP,
The best practice I've heard and use myself is a separate volume for each of
the following:
RAID 1 volume for OS and executables
RAID 10 if possible (RAID 5 if not) for SQL Server data files
RAID 10 or at least RAID 1 for log files
RAID 10 or RAID 1 for tempdb
RAID 5 for backups
This is in general; sometimes variations are required depending on
requirements. Some SAN vendors claim their RAID 5 flavors are just as fast
as RAID 1, but I can't verify that.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"JP" <aspento_quitar_para_correo_@.arrakis.es> wrote in message
news:OogXabz9EHA.1564@.TK2MSFTNGP09.phx.gbl...
> Hi. I've to install a server with SQL server and a RAID system. We've
> installed servers
> with SQL but without RAID systems. I want to know wich is the best
> configuration and how many disks
> to install RAID on a server wich only has to run SQL server. The RAID,
must
> be only for data or for
> data and the operating system at time?. Thanks a lot.
>|||Please read the documentation on http://www.baarf.com/ which explains why
RAID 5 is not a performing option.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2004 All rights reserved.
"Ron Talmage" <rtalmage@.prospice.com> wrote in message
news:%23mYi7kH%23EHA.3856@.TK2MSFTNGP10.phx.gbl...
> JP,
> The best practice I've heard and use myself is a separate volume for each
> of
> the following:
> RAID 1 volume for OS and executables
> RAID 10 if possible (RAID 5 if not) for SQL Server data files
> RAID 10 or at least RAID 1 for log files
> RAID 10 or RAID 1 for tempdb
> RAID 5 for backups
> This is in general; sometimes variations are required depending on
> requirements. Some SAN vendors claim their RAID 5 flavors are just as fast
> as RAID 1, but I can't verify that.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
>
> "JP" <aspento_quitar_para_correo_@.arrakis.es> wrote in message
> news:OogXabz9EHA.1564@.TK2MSFTNGP09.phx.gbl...
>> Hi. I've to install a server with SQL server and a RAID system. We've
>> installed servers
>> with SQL but without RAID systems. I want to know wich is the best
>> configuration and how many disks
>> to install RAID on a server wich only has to run SQL server. The RAID,
> must
>> be only for data or for
>> data and the operating system at time?. Thanks a lot.
>>
>
installed servers
with SQL but without RAID systems. I want to know wich is the best
configuration and how many disks
to install RAID on a server wich only has to run SQL server. The RAID, must
be only for data or for
data and the operating system at time?. Thanks a lot.> Hi. I've to install a server with SQL server and a RAID system. We've
> installed servers with SQL but without RAID systems. I want to know
> which is the best configuration and how many disks to install RAID
> on a server wich only has to run SQL server. The RAID, must be only
> for data or for data and the operating system at time ?
RAID Levels and SQL Server:
http://msdn.microsoft.com/library/en-us/optimsql/odp_tun_1_87jm.asp
Comparing Different Implementations of RAID Levels:
http://msdn.microsoft.com/library/en-us/optimsql/odp_tun_1_79pv.asp|||JP,
The best practice I've heard and use myself is a separate volume for each of
the following:
RAID 1 volume for OS and executables
RAID 10 if possible (RAID 5 if not) for SQL Server data files
RAID 10 or at least RAID 1 for log files
RAID 10 or RAID 1 for tempdb
RAID 5 for backups
This is in general; sometimes variations are required depending on
requirements. Some SAN vendors claim their RAID 5 flavors are just as fast
as RAID 1, but I can't verify that.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"JP" <aspento_quitar_para_correo_@.arrakis.es> wrote in message
news:OogXabz9EHA.1564@.TK2MSFTNGP09.phx.gbl...
> Hi. I've to install a server with SQL server and a RAID system. We've
> installed servers
> with SQL but without RAID systems. I want to know wich is the best
> configuration and how many disks
> to install RAID on a server wich only has to run SQL server. The RAID,
must
> be only for data or for
> data and the operating system at time?. Thanks a lot.
>|||Please read the documentation on http://www.baarf.com/ which explains why
RAID 5 is not a performing option.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2004 All rights reserved.
"Ron Talmage" <rtalmage@.prospice.com> wrote in message
news:%23mYi7kH%23EHA.3856@.TK2MSFTNGP10.phx.gbl...
> JP,
> The best practice I've heard and use myself is a separate volume for each
> of
> the following:
> RAID 1 volume for OS and executables
> RAID 10 if possible (RAID 5 if not) for SQL Server data files
> RAID 10 or at least RAID 1 for log files
> RAID 10 or RAID 1 for tempdb
> RAID 5 for backups
> This is in general; sometimes variations are required depending on
> requirements. Some SAN vendors claim their RAID 5 flavors are just as fast
> as RAID 1, but I can't verify that.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
>
> "JP" <aspento_quitar_para_correo_@.arrakis.es> wrote in message
> news:OogXabz9EHA.1564@.TK2MSFTNGP09.phx.gbl...
>> Hi. I've to install a server with SQL server and a RAID system. We've
>> installed servers
>> with SQL but without RAID systems. I want to know wich is the best
>> configuration and how many disks
>> to install RAID on a server wich only has to run SQL server. The RAID,
> must
>> be only for data or for
>> data and the operating system at time?. Thanks a lot.
>>
>
RAID FOR SQL
Hi. I've to install a server with SQL server and a RAID system. We've
installed servers
with SQL but without RAID systems. I want to know wich is the best
configuration and how many disks
to install RAID on a server wich only has to run SQL server. The RAID, must
be only for data or for
data and the operating system at time?. Thanks a lot.> Hi. I've to install a server with SQL server and a RAID system. We've
> installed servers with SQL but without RAID systems. I want to know
> which is the best configuration and how many disks to install RAID
> on a server wich only has to run SQL server. The RAID, must be only
> for data or for data and the operating system at time ?
RAID Levels and SQL Server:
http://msdn.microsoft.com/library/e..._tun_1_87jm.asp
Comparing Different Implementations of RAID Levels:
http://msdn.microsoft.com/library/e..._tun_1_79pv.asp|||JP,
The best practice I've heard and use myself is a separate volume for each of
the following:
RAID 1 volume for OS and executables
RAID 10 if possible (RAID 5 if not) for SQL Server data files
RAID 10 or at least RAID 1 for log files
RAID 10 or RAID 1 for tempdb
RAID 5 for backups
This is in general; sometimes variations are required depending on
requirements. Some SAN vendors claim their RAID 5 flavors are just as fast
as RAID 1, but I can't verify that.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"JP" <aspento_quitar_para_correo_@.arrakis.es> wrote in message
news:OogXabz9EHA.1564@.TK2MSFTNGP09.phx.gbl...
> Hi. I've to install a server with SQL server and a RAID system. We've
> installed servers
> with SQL but without RAID systems. I want to know wich is the best
> configuration and how many disks
> to install RAID on a server wich only has to run SQL server. The RAID,
must
> be only for data or for
> data and the operating system at time?. Thanks a lot.
>|||Please read the documentation on http://www.baarf.com/ which explains why
RAID 5 is not a performing option.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"Ron Talmage" <rtalmage@.prospice.com> wrote in message
news:%23mYi7kH%23EHA.3856@.TK2MSFTNGP10.phx.gbl...
> JP,
> The best practice I've heard and use myself is a separate volume for each
> of
> the following:
> RAID 1 volume for OS and executables
> RAID 10 if possible (RAID 5 if not) for SQL Server data files
> RAID 10 or at least RAID 1 for log files
> RAID 10 or RAID 1 for tempdb
> RAID 5 for backups
> This is in general; sometimes variations are required depending on
> requirements. Some SAN vendors claim their RAID 5 flavors are just as fast
> as RAID 1, but I can't verify that.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
>
> "JP" <aspento_quitar_para_correo_@.arrakis.es> wrote in message
> news:OogXabz9EHA.1564@.TK2MSFTNGP09.phx.gbl...
> must
>sql
installed servers
with SQL but without RAID systems. I want to know wich is the best
configuration and how many disks
to install RAID on a server wich only has to run SQL server. The RAID, must
be only for data or for
data and the operating system at time?. Thanks a lot.> Hi. I've to install a server with SQL server and a RAID system. We've
> installed servers with SQL but without RAID systems. I want to know
> which is the best configuration and how many disks to install RAID
> on a server wich only has to run SQL server. The RAID, must be only
> for data or for data and the operating system at time ?
RAID Levels and SQL Server:
http://msdn.microsoft.com/library/e..._tun_1_87jm.asp
Comparing Different Implementations of RAID Levels:
http://msdn.microsoft.com/library/e..._tun_1_79pv.asp|||JP,
The best practice I've heard and use myself is a separate volume for each of
the following:
RAID 1 volume for OS and executables
RAID 10 if possible (RAID 5 if not) for SQL Server data files
RAID 10 or at least RAID 1 for log files
RAID 10 or RAID 1 for tempdb
RAID 5 for backups
This is in general; sometimes variations are required depending on
requirements. Some SAN vendors claim their RAID 5 flavors are just as fast
as RAID 1, but I can't verify that.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"JP" <aspento_quitar_para_correo_@.arrakis.es> wrote in message
news:OogXabz9EHA.1564@.TK2MSFTNGP09.phx.gbl...
> Hi. I've to install a server with SQL server and a RAID system. We've
> installed servers
> with SQL but without RAID systems. I want to know wich is the best
> configuration and how many disks
> to install RAID on a server wich only has to run SQL server. The RAID,
must
> be only for data or for
> data and the operating system at time?. Thanks a lot.
>|||Please read the documentation on http://www.baarf.com/ which explains why
RAID 5 is not a performing option.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"Ron Talmage" <rtalmage@.prospice.com> wrote in message
news:%23mYi7kH%23EHA.3856@.TK2MSFTNGP10.phx.gbl...
> JP,
> The best practice I've heard and use myself is a separate volume for each
> of
> the following:
> RAID 1 volume for OS and executables
> RAID 10 if possible (RAID 5 if not) for SQL Server data files
> RAID 10 or at least RAID 1 for log files
> RAID 10 or RAID 1 for tempdb
> RAID 5 for backups
> This is in general; sometimes variations are required depending on
> requirements. Some SAN vendors claim their RAID 5 flavors are just as fast
> as RAID 1, but I can't verify that.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
>
> "JP" <aspento_quitar_para_correo_@.arrakis.es> wrote in message
> news:OogXabz9EHA.1564@.TK2MSFTNGP09.phx.gbl...
> must
>sql
Monday, March 26, 2012
RAID - Failure -- SQL Server Won't Start
Running a Dell 2400 dual CPU - 4 drive in a RAID-5
configuration. System was telling me I lost 2 drives
of the four - Forced restore (twice) after changing
different pices of hardware and everything seems to be
fine except SQL Server WON'T start --
reloaded - on top - SQL Developer Edition and SP 3a --
still no help --
1. If I remove SQL - what happens to my DBs?
2. Any other ideas would be great?
jed@.experiencedtechnology.comYour databses are unaffected by uninstalling and relaoding SQL Server - =the files will still be there but you will need to re-attach them.
More intersting is why will SQl Server not start - can you post the =contents of the error log file. There should be no need to re-install - =but any messages in the SQL Server error log will give us a clue.
Mike John
"Jim D" <anonymous@.discussions.microsoft.com> wrote in message =news:06ec01c3d78f$8e85bb90$a501280a@.phx.gbl...
> Running a Dell 2400 dual CPU - 4 drive in a RAID-5 > configuration. System was telling me I lost 2 drives > of the four - Forced restore (twice) after changing > different pices of hardware and everything seems to be > fine except SQL Server WON'T start --
> > reloaded - on top - SQL Developer Edition and SP 3a -- > still no help -- > > 1. If I remove SQL - what happens to my DBs?
> 2. Any other ideas would be great?
> > jed@.experiencedtechnology.com
configuration. System was telling me I lost 2 drives
of the four - Forced restore (twice) after changing
different pices of hardware and everything seems to be
fine except SQL Server WON'T start --
reloaded - on top - SQL Developer Edition and SP 3a --
still no help --
1. If I remove SQL - what happens to my DBs?
2. Any other ideas would be great?
jed@.experiencedtechnology.comYour databses are unaffected by uninstalling and relaoding SQL Server - =the files will still be there but you will need to re-attach them.
More intersting is why will SQl Server not start - can you post the =contents of the error log file. There should be no need to re-install - =but any messages in the SQL Server error log will give us a clue.
Mike John
"Jim D" <anonymous@.discussions.microsoft.com> wrote in message =news:06ec01c3d78f$8e85bb90$a501280a@.phx.gbl...
> Running a Dell 2400 dual CPU - 4 drive in a RAID-5 > configuration. System was telling me I lost 2 drives > of the four - Forced restore (twice) after changing > different pices of hardware and everything seems to be > fine except SQL Server WON'T start --
> > reloaded - on top - SQL Developer Edition and SP 3a -- > still no help -- > > 1. If I remove SQL - what happens to my DBs?
> 2. Any other ideas would be great?
> > jed@.experiencedtechnology.com
RAID - Failure -- SQL Server Won't Start
Running a Dell 2400 dual CPU - 4 drive in a RAID-5
configuration. System was telling me I lost 2 drives
of the four - Forced restore (twice) after changing
different pices of hardware and everything seems to be
fine except SQL Server WON'T start --
reloaded - on top - SQL Developer Edition and SP 3a --
still no help --
1. If I remove SQL - what happens to my DBs?
2. Any other ideas would be great?
jed@.experiencedtechnology.comYour databses are unaffected by uninstalling and relaoding SQL Server - =
the files will still be there but you will need to re-attach them.=20
More intersting is why will SQl Server not start - can you post the =
contents of the error log file. There should be no need to re-install - =
but any messages in the SQL Server error log will give us a clue.
Mike John
"Jim D" <anonymous@.discussions.microsoft.com> wrote in message =
news:06ec01c3d78f$8e85bb90$a501280a@.phx.gbl...
configuration. System was telling me I lost 2 drives
of the four - Forced restore (twice) after changing
different pices of hardware and everything seems to be
fine except SQL Server WON'T start --
reloaded - on top - SQL Developer Edition and SP 3a --
still no help --
1. If I remove SQL - what happens to my DBs?
2. Any other ideas would be great?
jed@.experiencedtechnology.comYour databses are unaffected by uninstalling and relaoding SQL Server - =
the files will still be there but you will need to re-attach them.=20
More intersting is why will SQl Server not start - can you post the =
contents of the error log file. There should be no need to re-install - =
but any messages in the SQL Server error log will give us a clue.
Mike John
"Jim D" <anonymous@.discussions.microsoft.com> wrote in message =
news:06ec01c3d78f$8e85bb90$a501280a@.phx.gbl...
quote:
> Running a Dell 2400 dual CPU - 4 drive in a RAID-5=20
> configuration. System was telling me I lost 2 drives=20
> of the four - Forced restore (twice) after changing=20
> different pices of hardware and everything seems to be=20
> fine except SQL Server WON'T start --
>=20
> reloaded - on top - SQL Developer Edition and SP 3a -- =20
> still no help --=20
>=20
> 1. If I remove SQL - what happens to my DBs?
> 2. Any other ideas would be great?
>=20
> jed@.experiencedtechnology.com
Tuesday, March 20, 2012
Quick sysobjects Question
Hi,
How do I distinguish user objects from system objects in the sysobjects
table (other than user tables and system tables)?
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
WHERE OBJECTPROPERTY(id, 'IsMsShipped') = 0
However, there are some gotchas, such as sysdiagrams, dtproperties, and
maybe some replication objects...
A
"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:%23aw9FX3BHHA.1220@.TK2MSFTNGP04.phx.gbl...
> Hi,
> How do I distinguish user objects from system objects in the sysobjects
> table (other than user tables and system tables)?
> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>
|||Hi,
Take a look into INFORMATION_SCHEMA views.
Thanks
Hari
"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:%23aw9FX3BHHA.1220@.TK2MSFTNGP04.phx.gbl...
> Hi,
> How do I distinguish user objects from system objects in the sysobjects
> table (other than user tables and system tables)?
> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>
How do I distinguish user objects from system objects in the sysobjects
table (other than user tables and system tables)?
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
WHERE OBJECTPROPERTY(id, 'IsMsShipped') = 0
However, there are some gotchas, such as sysdiagrams, dtproperties, and
maybe some replication objects...
A
"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:%23aw9FX3BHHA.1220@.TK2MSFTNGP04.phx.gbl...
> Hi,
> How do I distinguish user objects from system objects in the sysobjects
> table (other than user tables and system tables)?
> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>
|||Hi,
Take a look into INFORMATION_SCHEMA views.
Thanks
Hari
"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:%23aw9FX3BHHA.1220@.TK2MSFTNGP04.phx.gbl...
> Hi,
> How do I distinguish user objects from system objects in the sysobjects
> table (other than user tables and system tables)?
> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>
Quick sysobjects Question
Hi,
How do I distinguish user objects from system objects in the sysobjects
table (other than user tables and system tables)?
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.orgWHERE OBJECTPROPERTY(id, 'IsMsShipped') = 0
However, there are some gotchas, such as sysdiagrams, dtproperties, and
maybe some replication objects...
A
"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:%23aw9FX3BHHA.1220@.TK2MSFTNGP04.phx.gbl...
> Hi,
> How do I distinguish user objects from system objects in the sysobjects
> table (other than user tables and system tables)?
> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>|||Hi,
Take a look into INFORMATION_SCHEMA views.
Thanks
Hari
"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:%23aw9FX3BHHA.1220@.TK2MSFTNGP04.phx.gbl...
> Hi,
> How do I distinguish user objects from system objects in the sysobjects
> table (other than user tables and system tables)?
> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>
How do I distinguish user objects from system objects in the sysobjects
table (other than user tables and system tables)?
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.orgWHERE OBJECTPROPERTY(id, 'IsMsShipped') = 0
However, there are some gotchas, such as sysdiagrams, dtproperties, and
maybe some replication objects...
A
"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:%23aw9FX3BHHA.1220@.TK2MSFTNGP04.phx.gbl...
> Hi,
> How do I distinguish user objects from system objects in the sysobjects
> table (other than user tables and system tables)?
> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>|||Hi,
Take a look into INFORMATION_SCHEMA views.
Thanks
Hari
"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:%23aw9FX3BHHA.1220@.TK2MSFTNGP04.phx.gbl...
> Hi,
> How do I distinguish user objects from system objects in the sysobjects
> table (other than user tables and system tables)?
> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>
Quick sysobjects Question
Hi,
How do I distinguish user objects from system objects in the sysobjects
table (other than user tables and system tables)?
--
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.orgWHERE OBJECTPROPERTY(id, 'IsMsShipped') = 0
However, there are some gotchas, such as sysdiagrams, dtproperties, and
maybe some replication objects...
A
"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:%23aw9FX3BHHA.1220@.TK2MSFTNGP04.phx.gbl...
> Hi,
> How do I distinguish user objects from system objects in the sysobjects
> table (other than user tables and system tables)?
> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>|||Hi,
Take a look into INFORMATION_SCHEMA views.
Thanks
Hari
"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:%23aw9FX3BHHA.1220@.TK2MSFTNGP04.phx.gbl...
> Hi,
> How do I distinguish user objects from system objects in the sysobjects
> table (other than user tables and system tables)?
> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>
How do I distinguish user objects from system objects in the sysobjects
table (other than user tables and system tables)?
--
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.orgWHERE OBJECTPROPERTY(id, 'IsMsShipped') = 0
However, there are some gotchas, such as sysdiagrams, dtproperties, and
maybe some replication objects...
A
"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:%23aw9FX3BHHA.1220@.TK2MSFTNGP04.phx.gbl...
> Hi,
> How do I distinguish user objects from system objects in the sysobjects
> table (other than user tables and system tables)?
> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>|||Hi,
Take a look into INFORMATION_SCHEMA views.
Thanks
Hari
"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:%23aw9FX3BHHA.1220@.TK2MSFTNGP04.phx.gbl...
> Hi,
> How do I distinguish user objects from system objects in the sysobjects
> table (other than user tables and system tables)?
> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>
Monday, March 12, 2012
Quick SQL Mail Question
Hi all,
Here is a simple one.
Can I setup SQL mail on a server where the SQL service and agent accounts
are using the local system account? I think I need to set these services to
a domain account, correct?
TIA,
JoeSave yourself some hassle...
http://www.aspfaq.com/2403
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:1AF9ACF1-068E-472E-A547-6A2B30CB25FB@.microsoft.com...
> Hi all,
> Here is a simple one.
> Can I setup SQL mail on a server where the SQL service and agent accounts
> are using the local system account? I think I need to set these services
> to
> a domain account, correct?
> TIA,
> Joe
>
Here is a simple one.
Can I setup SQL mail on a server where the SQL service and agent accounts
are using the local system account? I think I need to set these services to
a domain account, correct?
TIA,
JoeSave yourself some hassle...
http://www.aspfaq.com/2403
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:1AF9ACF1-068E-472E-A547-6A2B30CB25FB@.microsoft.com...
> Hi all,
> Here is a simple one.
> Can I setup SQL mail on a server where the SQL service and agent accounts
> are using the local system account? I think I need to set these services
> to
> a domain account, correct?
> TIA,
> Joe
>
Quick SQL Mail Question
Hi all,
Here is a simple one.
Can I setup SQL mail on a server where the SQL service and agent accounts
are using the local system account? I think I need to set these services to
a domain account, correct?
TIA,
Joe
Save yourself some hassle...
http://www.aspfaq.com/2403
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:1AF9ACF1-068E-472E-A547-6A2B30CB25FB@.microsoft.com...
> Hi all,
> Here is a simple one.
> Can I setup SQL mail on a server where the SQL service and agent accounts
> are using the local system account? I think I need to set these services
> to
> a domain account, correct?
> TIA,
> Joe
>
Here is a simple one.
Can I setup SQL mail on a server where the SQL service and agent accounts
are using the local system account? I think I need to set these services to
a domain account, correct?
TIA,
Joe
Save yourself some hassle...
http://www.aspfaq.com/2403
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:1AF9ACF1-068E-472E-A547-6A2B30CB25FB@.microsoft.com...
> Hi all,
> Here is a simple one.
> Can I setup SQL mail on a server where the SQL service and agent accounts
> are using the local system account? I think I need to set these services
> to
> a domain account, correct?
> TIA,
> Joe
>
Wednesday, March 7, 2012
quick count of all tables in a database
How can I get a quick count of all tables in a database? Is there a way to do this? Can the table count exclude system tables?
What about this:
SELECT COUNT(*) FROM sys.tables WHERE is_ms_shipped=0
One problem is that "sysdiagrams" is not marked as is_ms_shipped=1. If you don't want to include it, add name <>'sysdiagrams' condition.
|||SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE LIKE 'BASE%'Monday, February 20, 2012
Questions to the Microsoft guys about the custom assembly
Hi Guys,
I created a custom assemy and added a reference to it in my report, but when I built the report, it told me that the system could not find the file. I followed the steps in the MSDN when I did the above steps. Can anybody tell me why?
Another question is about the location of the assmbly that I should copy. In the Debugging Custom Assemblie chapter on MSDN, it tells to copy my assembly to
C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE.
But in Deploying a Custom Assembly chapter, it tells me to copy it to
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies.
Can Microsoft guys tell me which is correct?
Thanks in advance.
Danny
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies is the correct location for the report designer in BI Development Studio.
-- Robert
|||Hi Robert,
Thank you very much for your answer. My another question is I can only refer to my custom assembly when I use strong name for the assembly and put it into GAC. Or else, the report designer just told me that the file or its dependecies counld not be found. But put the assembly into the GAC means I cannot debug my assembly. Could you give me some tips on this? (I followed all the steps I could find on the MSDN)
Thanks in advance.
Danny
Subscribe to:
Posts (Atom)