Performance
Tools and utilities
Guidelines, best practices
SQL 2008
Known problems
- 316749 - There may not be enough virtual memory when you have a large number of databases in SQL Server
- 906892 - You may experience slow performance when you run 32-bit SQL Server tools on 64-bit operating systems
- 929728 - An instance of SQL Server performs slowly when you use SQL Profiler to perform a client-side trace of the events in the instance
- 931279 - SQL Server timing values may be incorrect when you use utilities or technologies that change CPU frequencies
- 951935 - Query performance is slow when you run a query that contains an ORDER BY clause on a table column of an SQL tertiary collation
- 2000380 - SQL Server 2005 and SQL Server 2008 reports 701 errors with large batch sizes
- 2001221 - SQL Server reports 701: "There is insufficient memory to run this query" when executing large batches
- 2000395 - You may notice performance issues when using date literal values in distributed queries with third party OLEDB providers from SQL server.
- 2003031 - Query performance decreases when sys.dm_db_index_usage_stats has large number of rows
- 2009160 - High CPU utilization may occur with your queries on SQL Server 2005 and SQL Sever 2008 servers compared to SQL Server 2000
- 2028436 - Certain database operations take a very long duration to complete or encounter errors when the transaction log has numerous virtual log files
|
|
