Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ksr39
Posting Yak Master
193 Posts |
 Posted - 2011-02-09 : 01:22:17
|
| Hi all,i need a small help, how to find the performance of all(multi database) the databases which i have,is there any command to retrieve information.as i know that by using dbcc command(dbcc checkdb(database_name)) we can get for a single db.Thanks in advance |
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2011-02-09 : 03:01:00
|
| performance means any errors that came across the jobs n the behavior of the database. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-02-09 : 03:40:33
|
| CheckDB has nothing to do with performance. It does integrity checks, it checks the physical and logical structure of the database files for errors.Performance and errors are very different thngs. What exactly are you looking for?--Gail ShawSQL Server MVP |
|
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2011-02-09 : 03:57:22
|
| S exactly i need to check the physical and logical structure of the db files for errors.so, which command we need to use. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-02-09 : 04:34:04
|
| DBCC CheckDB. Run it with the NO_INFOMSGS option, so that it doesn't print all the useless info.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
DB's Performance