By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,332 Members | 1,427 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,332 IT Pros & Developers. It's quick & easy.

Monitor MS SQL Database

P: 1
I want to monitor MS SQL Server. ex Active trannsactions, average waiting time and so on. How can i do it. and tell me what should i refer in order to accomplish it. Please give me the source code
Feb 20 '07 #1
Share this Question
Share on Google+
1 Reply


sicarie
Expert Mod 2.5K+
P: 4,677
I want to monitor MS SQL Server. ex Active trannsactions, average waiting time and so on. How can i do it. and tell me what should i refer in order to accomplish it. Please give me the source code
There's a big difference in helping telling you how to accomplish that and giving you source code (which we are not allowed to do).

However, writing such a program is not difficult - and will introduce a lot of good programming topics. How often do you want to poll the database for this information?

(PS - You might want to figure out what your SQL query is going to be in the MS SQL forum - I'm still brushing up on mine for the project I'm writing right now - I doubt I'll be that helpful with that - these guys are better resources for that.)
Feb 20 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.