Poll: Database monitoring - your top suggestions

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Poll: Database monitoring - your top suggestions

Author

Topic

tfountain
Constraint Violating Yak Guru

491 Posts

Posted - 2008-06-30 : 14:14:08

I'm curious, if you could suppy a list of the top items, as a DBA, you think are the top priorities on your database server to monitor. From database statistics to CPU usage. The sky is the limit.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-30 : 23:09:27

Worst performed queries, disk i/o, memory usage.

svicky9
Posting Yak Master

232 Posts

Posted - 2008-07-01 : 02:00:53

Here is a list of a few things I Monitor

on the Performance Monitor...Go for Buffer Cache Hit Ratio --- should be > 95% always, PageFaults should be less, Index Statistics and Fragmentation (check DBCC Showcontig for Sql server 2000 and sys.dm_index_physical_Stats for 2005 and a loads of DMV's on 2005... SQL SERVER profiler for the Queries with more reads , writes and CPU....Execution Plan to determine whether the optmizer is using the appropriate indexes and to determine the type of join used by the index....Activity monitor for the Jobs and the Open Transactions that are currently running on the SQL server....SQL SErver Log ...Sql server Agent Log ...Database Mail Log(if you are using it) and then ...Event Viewer...Disk Space(xp_fixeddrive)...Log Truncations...Backups........My favourite is sysprocesses.

Vic

http://vicdba.blogspot.com

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2008-07-01 : 04:13:44

excellent list.. I could have sworn we work in the same company :D

quote:
Originally posted by svicky9

Here is a list of a few things I Monitor

on the Performance Monitor...Go for Buffer Cache Hit Ratio --- should be > 95% always, PageFaults should be less, Index Statistics and Fragmentation (check DBCC Showcontig for Sql server 2000 and sys.dm_index_physical_Stats for 2005 and a loads of DMV's on 2005... SQL SERVER profiler for the Queries with more reads , writes and CPU....Execution Plan to determine whether the optmizer is using the appropriate indexes and to determine the type of join used by the index....Activity monitor for the Jobs and the Open Transactions that are currently running on the SQL server....SQL SErver Log ...Sql server Agent Log ...Database Mail Log(if you are using it) and then ...Event Viewer...Disk Space(xp_fixeddrive)...Log Truncations...Backups........My favourite is sysprocesses.

Vic

http://vicdba.blogspot.com

--------------------
keeping it simple...

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-01 : 09:04:31

quote:
Originally posted by jen

excellent list.. I could have sworn we work in the same company :D

quote:
Originally posted by svicky9

Here is a list of a few things I Monitor

on the Performance Monitor...Go for Buffer Cache Hit Ratio --- should be > 95% always, PageFaults should be less, Index Statistics and Fragmentation (check DBCC Showcontig for Sql server 2000 and sys.dm_index_physical_Stats for 2005 and a loads of DMV's on 2005... SQL SERVER profiler for the Queries with more reads , writes and CPU....Execution Plan to determine whether the optmizer is using the appropriate indexes and to determine the type of join used by the index....Activity monitor for the Jobs and the Open Transactions that are currently running on the SQL server....SQL SErver Log ...Sql server Agent Log ...Database Mail Log(if you are using it) and then ...Event Viewer...Disk Space(xp_fixeddrive)...Log Truncations...Backups........My favourite is sysprocesses.

Vic

http://vicdba.blogspot.com

--------------------
keeping it simple...

What about spending time in SQLteam.com?

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2008-07-02 : 01:42:56

We also monitor : Jobs Failed,SQL Server and OS Logs , User Security , servers restarting

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-02 : 08:11:58

"We also monitor : Jobs Failed"

We get alerts for these.

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2008-07-03 : 01:53:31

sodeep , Do you use the SQL Server mail components or do you have your own custom process. ?

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-03 : 08:32:48

quote:
Originally posted by jackv

sodeep , Do you use the SQL Server mail components or do you have your own custom process. ?

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com

Yes we use DBmail and pagers for crucial jobs.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources