locked
SQL 2005 - Monitor Queries from Business Users RRS feed

  • Question

  • Hi all,

    I would like to monitor the queries that are send to our SQL 2005 by the business users. Preferably i'd like to have a near time overview with:

    User (who send query), Query (text) , ServerResponse (rows returned / deleted / updated)

    Is that possible in some way?

    (i'm sorry if i'm posting this in the wrong forum)

    Cheers,

    John

    Thursday, July 22, 2010 4:14 PM

Answers

  • Hello John,

    As I know, you can take a look at 'SQL Server Profiler' under the 'Performance Tool' folder of SQL Server2008 folder in the programmes. With which you can capture and save data about each event to a file or table to analyze later. For example, you can monitor a production environment to see which stored procedures are affecting performance by executing too slowly. http://msdn.microsoft.com/en-us/library/ms181091.aspx

    You can also post on SQL Server Forums(http://social.msdn.microsoft.com/Forums/en/category/sqlserver/) so you can get better and quicker response as this forum here is for the database development tools of Visual Studio.

    Thanks.


    Please remember to mark the replies as answers if they help and unmark them if they provide no help
    Friday, July 23, 2010 8:33 AM
    Moderator

All replies

  • Hello John,

    As I know, you can take a look at 'SQL Server Profiler' under the 'Performance Tool' folder of SQL Server2008 folder in the programmes. With which you can capture and save data about each event to a file or table to analyze later. For example, you can monitor a production environment to see which stored procedures are affecting performance by executing too slowly. http://msdn.microsoft.com/en-us/library/ms181091.aspx

    You can also post on SQL Server Forums(http://social.msdn.microsoft.com/Forums/en/category/sqlserver/) so you can get better and quicker response as this forum here is for the database development tools of Visual Studio.

    Thanks.


    Please remember to mark the replies as answers if they help and unmark them if they provide no help
    Friday, July 23, 2010 8:33 AM
    Moderator
  • Thanks Edwer!

    Sorry for the late response, i've been away for a couple of days. I know of the SQL Server Profiler, yet i'm looking for a way to build my own monitor tool in .Net. I didn't mention that in my post above. Thanks for your answer anyways.

    Cheers,

    John

    Saturday, July 31, 2010 2:58 PM