SQL Database monitor : How?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server Newbies » SQL Database monitor : How?

SQL Database monitor : How?

Rate Topic

Display Mode

Topic Options

Author

Message

Digs

Posted Monday, October 18, 2010 9:04 PM

SSC-Addicted

Group: General Forum Members
Last Login: Friday, April 12, 2013 12:27 PM
Points: 416, Visits: 542

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

Grant Fritchey

Posted Tuesday, October 19, 2010 6:37 AM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:41 AM
Points: 13,383, Visits: 25,189

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

Digs

Posted Tuesday, October 19, 2010 11:22 AM

SSC-Addicted

Group: General Forum Members
Last Login: Friday, April 12, 2013 12:27 PM
Points: 416, Visits: 542

Thanks

Post #1007174

« Prev Topic | Next Topic »

Permissions