Performance
Guidelines, best practices
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
- 911307 - The operation is delayed for several minutes when you run a Transact-SQL statement or a module that has an EXECUTE AS clause in SQL Server 2005
- 913395 - Error message when you use Database Engine Tuning Advisor in SQL Server 2005: "Attempt to initialize the CRT more than once"
- 915850 - You may experience a 45-second delay when you run a full-text query in an instance of SQL Server 2005 that is running on a server without Internet access
- 917828 - You may experience a decrease in query performance after you perform certain database maintenance operations or regular transaction operations in SQL Server 2005
- 918478 - When you connect to the SQL Server 2005 database engine, you may experience longer connection times
- 922118 - BUG: The User connections counter of the SQLServer:General Statistics performance object is not decremented when a Service Broker activation task is ended in SQL Server 2005
- 922121 - You may experience decreased performance in some features of SQL Server 2005 when you use EFS to encrypt database files
- 922658 - SQL Server 2000 or SQL Server 2005 may temporarily stop responding on a Windows Server 2003 Service Pack 1-based computer
- 927369 - Queries take a longer time to finish running when the size of the TokenAndPermUserStore cache grows in SQL Server 2005
- 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
- 936637 - The Batch Requests/sec counter of the SQL Statistics performance object increases one time for each RPC in SQL Server 2005 Service Pack 2
- 936891 - A memory leak may occur when the Merge Replication Agent retries a connection in SQL Server 2005
- 937086 - The full-text crawl takes a long time to finish when you create a full-text index on a column that has the varchar data type in SQL Server 2005
- 942982 - Performance is slow when you run a query in SQL Server 2005 that updates a table on a linked server and then joins the table to a table on the local server
- 949115 - Performance counter data is not updated when you run a tool that uses SQL Server performance counters to collect performance data against an instance of SQL Server 2005
- 949523 - The latency of a transactional replication is high in SQL Server 2005 when the value of the "Initial Size" property and the value of the Autogrowth property are small
- 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
- 952217 - A query that references a nondeterministic user-defined function may run slower in SQL Server 2005 than in SQL Server 2000
|
|
