Browse by Tags

Error: 'There is insufficient system memory to run this query' and 'Downgrading backup buffers from 960K to 64K"?

Published 28 March 8 4:31 AM | SSQA.net

Have you ever observed the error specified above? Do you need to worry for this issue, yes! First task to check what are the memory settings on SQL Server, by default they will be DYNAMIC and quite common that they might have set with MIN & MAX settings...

Filed under: sql server, memory, error, update statistics, buffers, memtoleave, downgrade, insufficient

Update Statistics on huge tables - best practice

Published 23 October 7 6:40 AM | SSQA.net

If you have valid indexes and they are maintained with regular schedule of reindexing to address fragmentation, then you can go with UPDATE STATISTICS on the tables that has frequent updates, say once in 2 days during the quiet time on the databases....

Filed under: sql server, performance, indexes, best practice, update statistics, indexed views

Update statistics causing negative performance

Published 17 August 7 8:11 PM | SSQA.net

Recently we have seen a negative performance for a query that is running against a 500GB size of database, where AUTO UPDATE STATISTICS is enabled and we perform weekly reindexing on this database. In addition to this I perform intermittent update statistics...

Filed under: sql server, performance, log, index, tempdb, best practice, update statistics, fragmentation

Usage and good practices with UPDATE STATISTICS feature in SQL 2005

Published 23 July 7 5:39 AM | SSQA.net

UPDATE STATISTICS is very helpful to get the performance by updating the distribution of key values for one or more statistics groups or set of collections in the specified table or indexed view. So how this is handled within the SQL Server, you may be...

Filed under: performance, security, dmv, query, optimization, tsql, statistics, update statistics