SQL Server Performance

monitoring cpu,memory,I/O usage with profiler

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by sqldbarocks, Jan 17, 2011.

  1. sqldbarocks New Member

    Hi
    Can some one pls help me in adding events and resolving CPU,Memory,I/O bottlenecks in sql server profiler ....is there any way to handle them in ssms itself??
    sqldbarocks, Jan 17, 2011
    #2

  2. satya Moderator

    Do you want to use PROFILER to monitor those events?
    Think about the resources issue as PROFILER is a heavy duty tool, in this case to obtain the status of these resources usage take help of DYnamic Management VIews (DMVs) see http://msdn.microsoft.com/en-us/library/ms188754.aspx for more information.
    satya, Jan 18, 2011
    #3

  3. sqldbarocks New Member

    Thanks satya for your post.in my senario there are always 50+ developers are hitting the server and finding 90 - 98 cpu utilisation in Taskmanager. and this is due to sql server instance installed on the computer server.even some times they are complaning about server memory also.
    Some one pls provide me the solution dmvs where I can sort out such problems.
    YOUR help is much appreciated :
    :) Have a nice time
    sqldbarocks, Jan 18, 2011
    #4

  4. sqldbarocks New Member

    Am I doing right by selecting dmv sys.dm_os_schedulers....?
    sqldbarocks, Jan 18, 2011
    #5

  5. satya Moderator

    satya, Jan 19, 2011
    #6

Share This Page