SQL Server Performance

DMVs to provide state of TEMPDB during a performance tuning analysis

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Aug 14, 2007.

  1. Anonymous New Member

    TEMPDB - though the name sounds like temporary database, it most important for any user database! Coming to performance tuning exercise or analysis you would go through Task Manager initially to see how system's memory &amp; processor are coping up. Though they give initial picture of usage it is always better to go through by SYSMON counters, so to be specific about application database performance refer to SQL Server performance counters that will provide information about the system performance...(<a href="http://sqlserver-qa.net/blogs/perftune/archive/2007/08/14/1415.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1415" width="1" height="1">

Share This Page