Announcement

Collapse
No announcement yet.

SQL Server 2K8 Performance monitoring

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL Server 2K8 Performance monitoring

    Hello,

    I have third party application which writes data to SQL Server 2K8 R2 and each time SQL server is being updated with the data i can see that its taking high cpu consumption, over 60 %. Can someone advise me on the performance counters i need to use to monitor the server?
    Any help is greatly appreciated.

    Thank You

    Salim

  • #2
    Re: SQL Server 2K8 Performance monitoring

    Check out PAL (Performance Analysis of Logs)

    http://pal.codeplex.com/

    It was created by a Microsoft employee for analysis of logs. It has a perfmon sql template you can export from within the program either XML or htm depending on your OS

    Also another tool is Sql Live Monitor I don't remember if it works with 2008 R2 but you can give it a look
    http://sqlmonitor.codeplex.com/
    Last edited by DietMountainDewFTW; 4th January 2012, 19:56.

    Comment

    Working...
    X