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 ...
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 ...
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 ...
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.
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 ...