here is a simple question, but just recently this issue is really causing havoc
imagine i have a stored proc that simply select some rows and it takes 10 seconds to run it query analyzer...now imagine i run this same query 2 times concurrently through query analyzer and now it takes 18 seconds for each one to run...is this normal behavior for sql server and if so how do get around this...keep in mind, i am talking very generally here simple select statement the nolock hint...i have tried this on many servers, with no other sql usage going on at the same time with the same reaults more or less on each server
any help will be appreciated...thanks
-keith
imagine i have a stored proc that simply select some rows and it takes 10 seconds to run it query analyzer...now imagine i run this same query 2 times concurrently through query analyzer and now it takes 18 seconds for each one to run...is this normal behavior for sql server and if so how do get around this...keep in mind, i am talking very generally here simple select statement the nolock hint...i have tried this on many servers, with no other sql usage going on at the same time with the same reaults more or less on each server
any help will be appreciated...thanks
-keith