February 12, 2004 at 8:47 am
Not having a lot of success here. I am trying to prove or disprove that a table spread across multiple files (and drives) and is scanned, will utilize more threads than if the table is in one file.
So my question is to the mighty NT and SQL Server gurus is this..How can I verify the number of threads utilized for a table scan?
"Keep Your Stick On the Ice" ..Red Green
February 12, 2004 at 9:09 pm
I guess one way is to run SQLSERVR.EXE -f -m and grab the single connection immediately with Query Analyzer.
At this stage Task Manager's Processes tab whould show something like 20 in the threads column. Running your query should show the number of threads increasing by 1 or more.
Cheers,
- Mark
February 16, 2004 at 7:46 am
Thanks for the input. I will give it a try 🙂
"Keep Your Stick On the Ice" ..Red Green
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply