Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Database monitor : How? Expand / Collapse
Author
Message
Posted Monday, October 18, 2010 9:04 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 4:00 PM
Points: 420, Visits: 560
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)
Post #1006691
Posted Tuesday, October 19, 2010 6:37 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:23 PM
Points: 15,664, Visits: 28,062
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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1006913
Posted Tuesday, October 19, 2010 11:22 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 4:00 PM
Points: 420, Visits: 560
Thanks
Post #1007174
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse