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: 32 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
Career move from DBA to dbDeveloper
How can I make my work easy as a DBA
Error message in restoring database
BCP Error SQLState = S1000, NativeError = 0 , Unable to open BCP host data-file
Triage check list for SQL Server
How a DBA can perform Database maintainance activities with restricted access to DATA?
Database performance issue
Create database table from XSD