November 19, 2009 at 3:22 am
Hi,
I have been to put up some daily health scans on our SQL Server.
Can some one please suggest some useful scans and how to create them.
thanks
November 19, 2009 at 8:46 pm
You might try the SQL Server Health and History Tool (SQLH2). Free download from Microsoft.
Steve
SQL Managed
November 19, 2009 at 9:51 pm
Are you running backups? Check on those.
Are you checking for fragmentation? Disk space? Free space in files? All the daily maintenance that should occur on your server is something you can check for.
November 19, 2009 at 11:38 pm
You should run DBCC CHECKDB on a regular basis - maybe not daily (and here I am a little "off topic") - but I think that you should not forget about this. The "Data corruption" section of this forum offers many instructive stories...
November 20, 2009 at 12:10 am
you can configure the health checks from the maintenance wizard or use some tools like health and history checkup which can be downloaded freely.
November 20, 2009 at 1:49 am
to continue with what Steve suggested....
If 3rd Party tools are not available, build your own and very accurate health check system with perfmon.
include the SQL counters for growth, fragmentation, backups, log's, IO errors, blocks, any jobs that failed etc..
scrubbing the data is a bit of a mission, but will give good results.
Some (note-only some, not all) of the counters I use (personal preference)
1. Buffer cache hit ratio
2. Page Life Expectacy
3. Number of deadlocks/sec
4. Per DB, include a Data File Size, Log file size
hope this helps a bit?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply