http://www.sqlhacks.com/Administration/Memory-UsageMemory is one the most important factor affecting MSSQL performance.As an administrator, you should be monitoring the memoryregularly. Wh

http://www.databasejournal.com/features/mssql/article.php/3771871/SQL-Server-2008-Data-Collections-and-the-Management-Data-Warehouse.htmhttp://www.sql-server-performance.com/articles/per/Management_Data_Warehouse_p2.aspxhttp://www.databasejournal.com/featu

<br />SQL Server 2005 Performance Troubleshooting Resources (http://blogs.technet.com/b/sqlman/archive/2008/12/13/sql-server-2005-performance-troubleshooting-resources.aspx)<br /> Top 10 SQL Server 2005 Performance Issues for Data Warehouse and Reporting A

<br />http://archive.databasepronews.com/databasepronews-51-20041207UsingPerformanceMonitortoIdentifySQLServerHardwareBottlenecks.html<br /> <br />The best place to start your SQL Serverperformance audit is to begin with the Performance Monitor (System

<br />1. I/O Statistics in individual databaseselect num_of_reads, num_of_bytes_read,<br />num_of_writes, num_of_bytes_written<br />from sys.dm_io_virtual_file_stats(db_id('tempdb'), 1)<br /><br /><br />This is the output:<br />num_of_reads = 5643 num_

<br />http://adminfoo.net/2007/04/windows-perfmon-top-ten-counters.html<br />windows perfmon top ten counters<br /> <br />Bottleneck analysis<br />The most common use of PerfMon is to answer the burning question: why is my system running slow?<br /><br />

<br />http://www.sql-server-performance.com/tips/sql_server_performance_monitor_coutners_p2.aspx<br /> <br />Issue<br />Performance Counter<br />Normal value <br />Solution<br />Monitor Level<br />large number of page splits<br />SQL Server Access Methods

http://www.experts-exchange.com/Web_Development/WebTrends_Stats/Q_23545979.htmlObject: ASP.NETCounter: Request Execution TimeExplanation:The number of milliseconds that it took to execute the most recentrequest. (for some reason this is a differe

System counterDescriptionIdeally AverageIssueSolutionMemory: Pages/secThis counter measures the number of pages per second that are pag