Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Database monitor : How?


SQL Database monitor : How?

Author
Message
Digs
Digs
SSC-Addicted
SSC-Addicted (421 reputation)SSC-Addicted (421 reputation)SSC-Addicted (421 reputation)SSC-Addicted (421 reputation)SSC-Addicted (421 reputation)SSC-Addicted (421 reputation)SSC-Addicted (421 reputation)SSC-Addicted (421 reputation)

Group: General Forum Members
Points: 421 Visits: 564
HI,

My client software is ASP.net 2.0 is on a SHARED sql server hoster provider. I use ADO to create a connection to MSSQL database to run many TSQL stored procedures. I am using aspnetdb database for members management.

How can I
1) Monitor or count the number of members logged onto the SQL database.
2) Monitor or count the number of ado connections to SQL database.
3) Monitor or count database statistics etc.

My hoster let me use the Plesky software to monitor and use database, but its slow)
Grant Fritchey
Grant Fritchey
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17647 Visits: 32268
I don't know what the Plesky software is, so I can't help there.

If you can't run performance monitor on the server, but you are still interested in getting some of the counters available from there, you can use dynamic management objects (DMO) to access this. For example, to see the workers connected to and operating in the OS, you can use sys.dm_os_workers. To see activity directly against the SQL instance, you can use sys.dm_exec_requests, which will show currently executing procedures. To check on statistics on tables, etc. you can use sys.dm_db_index_physical_stats.

There are a whole ton of ways you can check on the system using DMOs. There's a great new book, focused on performance tuning with them called "Performance Tuning with SQL Server Dynamic Management Views" by Louis Davidson & Tim Ford. I highly recommend it.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Digs
Digs
SSC-Addicted
SSC-Addicted (421 reputation)SSC-Addicted (421 reputation)SSC-Addicted (421 reputation)SSC-Addicted (421 reputation)SSC-Addicted (421 reputation)SSC-Addicted (421 reputation)SSC-Addicted (421 reputation)SSC-Addicted (421 reputation)

Group: General Forum Members
Points: 421 Visits: 564
Thanks
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search