October 18, 2010 at 9:04 pm
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)
October 19, 2010 at 6:37 am
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 19, 2010 at 11:23 am
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply