The tag has no usage guidance.

learn more… | top users | synonyms (1)

0
votes
0answers
37 views

Looking for additional ideas on transaction log waits

We are seeing high Log Waits on our SQL Servers. Our Production server can be in the hundreds of milliseconds. We are running SQL Server 2008 R2 on Win 2008 R2. The server is virtual using VMware. ...
0
votes
0answers
26 views

I/O Stall Waits on SSD

I have a 1.2 Tb database stored on 1 ssd drive as 1 mdf datafile. I am experiencing high I/O stall waits on that datafile average 10.5 but often has high as 40. I have identified many useless indexes ...
0
votes
0answers
45 views

Oracle 11gR2 + RHEL 6.5 free buffer waits

Good day, For some strange reason I get the "FREE BUFFER WAITS" warning after loading (SQLLDR) for a couple of hours. The system then becomes extremely slow.I am loading around 2+ million records per ...
1
vote
1answer
58 views

DIRTY_PAGE_POLL without activated Indirect Checkpoint

Since I encounter some performance issues on my SQL Server 2014 (12.0.2370.0 (X64)) I'm dealing with enormes amounts of different wait types. One of the top 5 wait type is "DIRTY_PAGE_POLL". I've ...
0
votes
1answer
45 views

Does dm_exec_procedure_stats.total_worker_time include signal waits?

Does sys.dm_exec_procedure_stats.total_worker_time include signal waits or only time spent by procedure on scheduler? The reason of question - when number of cores was increased on the server signal ...
0
votes
0answers
98 views

How can I have long waits on Tracewrite, when I haven't run Profiler?

I recently setup a SQL Server which is used only ot run a sharepoint Server. I love to query my wait stats, just to see what we are waiting on. Most of the wait stats are fine, and I know where they ...
3
votes
1answer
340 views

SQL Server: dm_exec_requests.wait_time vs. dm_exec_sessions.last_request_end_time

We have a third-party Microsoft Access application that uses SQL Server 2012 as its data store. It is a well known issue that Access often does not tell SQL Server that it has received the results of ...
3
votes
2answers
1k views

Is it safe to cancel a PostgreSQL ALTER TABLE query that is waiting on a lock?

We started an ALTER TABLE query hours ago and only recently realized (via pg_stat_activity) that it is waiting on a lock. We discovered the other query that is holding a lock on the table we want to ...
3
votes
1answer
558 views

Confused about sys.dm_io_virtual_file_stats num_of_reads/writes column

I'm trying to use the sys.dm_io_virtual_file_stats DMF to generate so IO wait information across a number of my servers. I came across this post by Paul Randall: http://www.sqlskills.com/blogs/paul/...
0
votes
0answers
294 views

SLEEP_TASK and PAGELATCH_XX peaking after upgrade to R2 SP1

I wanted to just add a comment to this question: SLEEP_TASK Wait Type in SQL Server - What does it indicate? But I'm having not only SLEEP_TASK wait but also PAGELATCH_SH and PAGELATCH_EX wait types. ...
4
votes
1answer
993 views

Print message comes out in batches

I have simple query WHILE ( @counter < 50 ) BEGIN BEGIN TRANSACTION PRINT 'Counter = ' + CONVERT(VARCHAR(4), @counter); WITH CTE AS ( ...
2
votes
1answer
227 views

High Query Wait Times

We are seeing the below query as regularly having very high wait stats. What does this query relate to? System tables? Is it possible to reduce it's wait time? Thanks! select @reservedpages = sum(a....
7
votes
1answer
927 views

Specific TempDB insert of UserDB select results in SOS_SCHEDULER_YIELD to ENCRYPTION_SCAN

One of our production systems has exhibited a problem with a single insertion statement into a temp table from our user database. When I comment out the insert/select, the stored proc in question runs ...
2
votes
1answer
1k views

mysql “Lock wait timeout exceeded” two transaction with different keys indexed

I have set of tables that I need to delete their records with a specific key and insert new records. Different transactions are used one for each key: Transaction 1: DELETE FROM table1 WHERE id=1; --...
0
votes
3answers
9k views

Why decrease the wait_timeout configuration parameter in MySQL?

Question I'm working on an application that uses a connection pool in Apache Tomcat to communicate with MySQL. I was wondering why would you want to use a smaller wait_timeout than the default of 28,...
2
votes
1answer
796 views

OLEDB Wait Type and Functions

Is there any relationship between the OLEDB Wait Type and functions? Trying to troubleshoot why I would have 77% of my waits as OLEDB wait type when we have no linked servers. I have a vendor database ...
5
votes
1answer
839 views

Need help with ASYNC_NETWORK_IO

We have a SQL Server 2005 server that is serving up 20 websites, one of which is our custom CMS, and a few other micro sites. I am new to this and just started looking at the databases here. The ...
1
vote
2answers
361 views

Shared memory connection experiencing network wait type

I have a poorly written application running a SELECT *, resulting in a 2MB result set every few seconds. I cannot correct this. I am confused though,by the connection encountering ASYNC_NETWORK_IO ...
28
votes
2answers
9k views

Find Queries that Are Causing Waits

Given a certain kind of wait, how do you find which queries are causing those waits safely on a production SQL 2008 R2 Server? In this particular case I am wondering about async_network_io.
1
vote
1answer
9k views

Asynch Descriptor Resize explanation

What do asynch descriptor resize wait events mean on an Oracle 11g database running on Windows 2008 R2? According to My Oracle Support, this event applies to any platform, but the description ...