Search Results | SQL Server Performance Forums

Automating Reindexing In SQL Server 2000

Post by: cbabino, Jun 29, 2005 in forum: Performance Tuning for DBAs

Just turn off quoted iidetifiers and it will work.

There is insufficient system memory to run this qu

Post by: cbabino, Jun 27, 2005 in forum: Performance Tuning for DBAs

The following is what microsoft told us. Apparently processing data using a linked server specifially the fox pro driver causes memory leakage which...

There is insufficient system memory to run this qu

Post by: cbabino, Jun 11, 2005 in forum: Performance Tuning for DBAs

I just checked today and it is still happening, even though the tran log is backing up every hout instead of 15 mins. I don't know what else to...

There is insufficient system memory to run this qu

Post by: cbabino, Jun 10, 2005 in forum: Performance Tuning for DBAs

I have changed the transaction log backups back to 1 hour and will monitor it the next few days. I will let you know. I appreciate your help. Thanks

There is insufficient system memory to run this qu

Post by: cbabino, Jun 10, 2005 in forum: Performance Tuning for DBAs

We run the transaction log backups every 15 minutes. Actually u know what, this may have started happening after we changed the transaction log...

There is insufficient system memory to run this qu

Post by: cbabino, Jun 10, 2005 in forum: Performance Tuning for DBAs

How do you optimize the transaction log backup?

There is insufficient system memory to run this qu

Thread by: cbabino, Jun 10, 2005, 16 replies, in forum: Performance Tuning for DBAs

Every few days we get the error message "There is insufficient system memory to run this query. " When running the transaction log backup. The only...