processes box show wait time 0 but the waiting tasks in activity monitor shows 4
how can i solve that ?
Dec 15, 2017 at 02:25 PM
Dec 15, 2017 at 03:14 PM
Query sys.dm_os_waiting_task and not the wait stats DMV, the later is not going to show you currently active task running on the system.
Dec 18, 2017 at 05:19 AM
Jan 03 at 12:14 PM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
dba developer x19
asked: Dec 15, 2017 at 02:25 PM
Seen: 67 times
Last Updated: Jan 03 at 12:14 PM
SQL server becomes slower when i copy backup files to another server
Column level decryption returns NULL value at my destination DB, am using export/import to transfer my encrypted data between servers
SQL server maintenance plan Cannot rebuild clustered index offline?
Recent Computer Science graduate wanting to get an SQL job asap
Triage check list for SQL Server
Sql server dynamic IP port range?
SQL Server evaluation license related
Database performance issue
Free SQL scrubbing tools?
Database maintenance plan update statistics error