During the troubleshooting using Wait Stats in SQL Server, we need to know what are the common wait types in order to take proper actions. Further, we need to know what are the actions you should not take. Though the above table has very limited, the most common wait types, there are ...
The WRITELOG wait type is one of those wait types that can often be seen quite frequently on SQL Server, and that can cause a lot of headaches for DBAs. The WRITELOG wait time represents the time that accumulates while waiting for the content of the transaction log cache to be flushed t...
Connection string in ssis(Windows authentication) Connectivity issue with Oracle Source Consider using the WITH RESULTS SETS calus_metadata could not be determined because statement 'exec sp_executesql contains dynamic sql_e to explicity describe the ressults Conversion between types DT_DATE and D...
So this one would have had a dirty shut down due to the host failing and then would have been migrated to another server in the failover cluster. Once I finally managed to get logged on to the server (which took the best part of another hour) the whole server was slow to respond. I...
Note that not all the CXPACKET wait types are bad. You might experience a case when it totally makes sense. There might also be cases when this is unavoidable. If you remove this particular wait type for any query, then that query may run slower because the parallel operations are...