Viewing 3 posts - 1 through 3 (of 3 total)
Lets give it a shot!
Stay with the original settings. And try to repro.
Look at sys.dm_exec_requests and see what is the wait_type. If it is cx_packet, query sys.dm_os_waiting_tasks for...
June 13, 2012 at 2:48 pm
#1500688
The DTA recommended index is way too liberal. I think that you have the correct index in place. If your predicates are going to be fixed, consider whether you can...
May 21, 2012 at 1:25 pm
#1490668
Probably you are seeing this.
http://support.microsoft.com/kb/322854
May 17, 2012 at 5:20 pm
#1489416