What do u mean by worker threads in SQL server2000??
Database
3
Posts
2
Posters
0
Views
1
Watching
-
advantage and disadvantage of it?? thanks in advance.
-
advantage and disadvantage of it?? thanks in advance.
In short, worker thread is the actual thread serving a call to the database.
Aman786Singh wrote:
advantage and disadvantage of it
There's no choice in this. This is how SQL Server works.
The need to optimize rises from a bad design.My articles[^]
-
In short, worker thread is the actual thread serving a call to the database.
Aman786Singh wrote:
advantage and disadvantage of it
There's no choice in this. This is how SQL Server works.
The need to optimize rises from a bad design.My articles[^]
How to get which process is deadlocking the system?? how to know current connections establish?? Thanks in Advance.