Viewing 6 posts - 1 through 6 (of 6 total)
You could schedule more frequent TLOG backups during the time the job is running and that may help you out. There is always an "it depends" disclaimer with SQL but...
October 1, 2012 at 5:29 am
Other Performance Counters:
The following counters are incremented when the 'get' call is made to the buffer pool to satisfy access to a specific database page.
Description
Buffer Node: Local node...
August 6, 2012 at 3:45 pm
I am seeing the same thing on one of my server I just looked at. The is a 4 processor (x 6 core each) box with 128 GB of...
August 6, 2012 at 3:43 pm
Thanks Gail and Kevin... I worked withe the storage team and got the log file moved to dedicated spindles. Once we did this, we were able to see...
July 20, 2012 at 8:54 am
Thanks for the reply. When we increase MAX DOP above 1, the application experiences an increase in deadlocks and I think that is the reason for their setting.
Also, I...
July 18, 2012 at 2:00 pm
MAX DOP is 1 and Hyperthreading is off per the vendor recommended settings. This server is 100% Ad Hoc SQL for its workload. We have SQL tuned for...
July 16, 2012 at 4:08 pm
Viewing 6 posts - 1 through 6 (of 6 total)