From: Bero on 26 Jul 2010 19:11 Why is SQL Server 2005 open 40-50 threads for same SPID for a given database at times and goes back to sleep and will have only 2-3 threds per SPID at other times. How does SQL Server processes when you issue rebuild indexes via MP?
|
Pages: 1 Prev: Linked server query Next: Questions regarding Data center operation |