June 24, 2004 at 7:41 am
Does anybody have a script that does a simple "health check" of a SQL server? Something that lists data files and their sizes, local disks and their free space and/or other important stuff. Really anything would be good.
June 24, 2004 at 9:03 am
exec master..xp_fixeddrives
exec sp_helpdb 'Optional your DB name'
exec sp_helpfile 'Optional your DB file name'
Please refer to books online and check DBCC statements too!
June 24, 2004 at 10:10 am
There are tons of these scripts using different methods and collecting different types of data.
Check out the scripts on this site.
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
June 24, 2004 at 11:38 am
You can run sqldiag.exe from the command line. It will give you all ( and more ) the information you may need.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply