Performance monitoring from client

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Performance monitoring from client

Performance monitoring from client

Rate Topic

Display Mode

Topic Options

Author

Message

y.koteswarrao-652921

Posted Sunday, October 04, 2009 10:00 PM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 14, 2010 6:06 AM
Points: 76, Visits: 199

Hi,

This is question has been asked by the interviewer , how to monitor the performance of the server from the client side?

can anybody help me

thanks
Koteswarrao

Post #797649

jagadeesanpv

Posted Monday, October 05, 2009 2:52 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Saturday, March 30, 2013 6:06 AM
Points: 532, Visits: 224

Hi,

We can use Dynamic Management Views to monitor performance

'sys.dm_os_performance_counters' This DMV makes it possible to query a view directly to capture the SQL Server counters related to the instance

Regards,

Jagadeesan

Post #797720

Silverfox

Posted Monday, October 05, 2009 2:57 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 6:50 AM
Points: 2,719, Visits: 1,065

true but that is only a snapshot at that time.

--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw

Post #797721

Silverfox

Posted Monday, October 05, 2009 3:00 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 6:50 AM
Points: 2,719, Visits: 1,065

although you can use profiler as that is a client tool

--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw

Post #797723

Grant Fritchey

Posted Monday, October 05, 2009 9:38 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 3:57 PM
Points: 13,371, Visits: 25,152

Performance Monitor (perfmon) and dynamic management viewws (DMV's) are best. You can also browse the trace events from a server side trace on the client machine using Profiler. I would not recommend running Profiler against a production system directly. You can also look at the Activity Monitor through Management Studio, but that's just showing you the output of queries against the DMV's.

----------------------------------------------------
"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 #798007

SQLBalls

Posted Monday, October 05, 2009 9:50 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 8:21 AM
Points: 385, Visits: 610

you've got several options, depending on the version you've got and what tools you can install on your local desktop.

Activity Monitor, but it doesn't auto refresh in 2000, you set the refresh rate in 2005, and it is automatic and has a lot of info on 2008

DMV's and DMF's (but you need to know what they do and why you would look at them) You can execute these locally but technically they execute on the server.

Perfmon Counters (these are server side but you pull them down and agrigate them client side)

You could use Profiler (short term), but if you run Profiler too long from a client station it will hog up resources and can really degrade your server performance (trust me found out the hard way on this one). I would recommend server side trace files, and again you could pull them down locally and examine the results.

I think the big question is what do they mean on the client side, everything you pull is coming from the server and can be gathered at that end as well if you have the db tools installed.

Twitter: @SQLBalls
Blog: http://www.SQLBalls.com

Post #798016

« Prev Topic | Next Topic »

Permissions