Performance monitoring from client

  • 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

  • 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

  • true but that is only a snapshot at that time.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

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

  • although you can use profiler as that is a client tool

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

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

  • 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

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • 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.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply