MS SQL Server - what all needs to be monitored using NMS

Question

MS SQL Server - what all needs to be monitored using NMS

acpravin

SSC Rookie

Points: 40
More actions
October 9, 2007 at 3:07 am

#182632

Hi, I wanna know what all needs to be monitored in a MS SQL Server through NMS from a Customer Service provider point of view.
Apart from the CPU Usage, Memory usege etc... what are the other vital things that needs to be monitored.
Please let me know.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 728164 More actions · Answer 1

Couple things. First, what version? Second, what's NMS?, third, please post in the appropriate forum. I'm moving to SQL 2005, Performance.

For monitoring, I just do the basics for a baseline. CPU %, Memory reads/sec, Disk I/O for each physical drive, users and transactions/sec. If there's something wrong, I might dig in more.

Do not set alerts unless you know what your baselines are. SQL will jump to 100% CPU at times and that's normal based on activity.

Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com

acpravin SSC Rookie Points: 40 More actions · Answer 2

Hi,

Thanks for the reply, it was well informative.

I will get back with more details.

BTW, NMS is Network Management Software.

Regards

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 3

there must be a clue in there somewhere? Network Management - you need a sql server management/monitoring tool. I use Idera SQL Diagnostic Manager - excellent product. What you monitor relates to the use of your server and then what you might or might not do or be able to do given a raised alert. e.g. cpu, let us say you raise an alert at over 80% , given an alert on the very busy production system - lets say a banking system what would you actually propose to do?

I'm a great believer in monitoring and trending sql server(s) but I will take delight in tearing to bits users/admins who add alerts and monitoring but have no idea on what they're actually seeing, what it means or what you should do about it, assuming that you actually can.

So workout what and why and what your response will be - don't just spam yourself with messages - you might find it's better to collect and analyse stats for trending rather than enabling lots of alerts.

btw. one of my favourites is a memory alert set on a sql server with awe enabled!!

[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/

dots67 SSC Veteran Points: 210 More actions · Answer 4

I dont know what is NMS

I monitor nCPU, IO and locks using this: http://www.sqlsolutions.com/products/IO%20Activity%20Monitor/index.html