The wait-types tag has no wiki summary.
5
votes
1answer
49 views
Troubleshooting SOS_SCHEDULER_YIELD wait
Running our corporate ERP (Dynamics AX 2012), I noticed our production environment seemed much slower than our development systems.
After performing the same activities in both the development and ...
6
votes
1answer
105 views
LATCH_EX Waits on Resource METADATA_SEQUENCE_GENERATOR
We have a process that generates an inventory report. On the client side, the process splits of a configurable number of worker threads to build a chunk of data for the report that corresponds to one ...
3
votes
3answers
186 views
Investigating high SQL waits, especically LCK_M_U
Recently I have been struggling with SQL server performance and although we have fixed a huge multitude of basic errors in the config it is still performing badly. To clarify it is not overall ...
1
vote
4answers
1k views
Select from linked server to local server causing waits on both sides
The queries in question are here: http://pastie.org/4833351
Run individually, each of these queries runs through (albeit slow).
Run as a group, it just sits there, showing either OLEDB waits on the ...
2
votes
1answer
342 views
Is the SQLTRACE_FILE_BUFFER wait type documented? What does it indicate?
We run a background task on one of our servers which polls sys.dm_exec_requests for long-running queries, gathering diagnostic information when it finds them, including wait type.
I'm seeing a number ...
6
votes
1answer
273 views
Attempting to tune a Sharepoint site using SQL Server Waits and Queues
I'm pretty new to this performance tuning with Waits and Queues thing - fascinating, but also not always all that intuitive...
Right now, a customer of mine has a SQL Server 2008 64-bit Enterprise ...
5
votes
2answers
8k views
How to troubleshoot enq: TX - row lock contention?
I have the following situation.
I have RAC. On both nodes there are the locks.
On the First Node
SID EVENT USERNAME BLOCKING_SESSION ROW_WAIT_OBJ# OBJECT_NAME ...
3
votes
3answers
914 views
PageIOLatch_Sh waits noticed after tuning an index
Lately, a lot of queries to the database are timing out. While investigating I found that queries are in the suspended state with wait_type as PageIOLatch_Sh. I have not noticed so many queries being ...
2
votes
1answer
453 views
async_network_io issues with BIDS
This is related to my previous question drastically different runtimes in BIDS and the SSRS Web Portal.
I am struggling with refreshing some reports in BIDS because they run forever. I have now ...
14
votes
1answer
3k views
SLEEP_TASK Wait Type in SQL Server - What does it indicate?
I haven't seen the SLEEP_TASK wait type before, and today I seem to be getting a ton of them.
I'm not the official DBA, just a SQL Server developer who knows some DBA stuff. We upgraded our servers ...
