March 10, 2009 at 7:39 am
Hi,
The same query runs in 1 second when logging into my DB using Windows Authentication login, but timesout (never finishes) when using a sql login (inc. sa).
I cant compare the actual query plans (as sa login query doesn't finish)
any clues?
any help is appreciated
thx
jag
March 10, 2009 at 7:47 am
Are you using the exact same query at both times? Does the query’s result have any connection to the person that is running the query (for example - like querying the information_schame views)?
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 10, 2009 at 12:51 pm
Do both connections have the same settings? You can check this by looking at the connection information in a trace, either existing connections or logins.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 13, 2009 at 10:12 am
hi, a fellow DBA sorted it by updating the statistics on one of the table.
dont ask me why stale statistics affected one user and not the other???
March 13, 2009 at 10:23 am
Different parameters?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 13, 2009 at 10:44 am
the query was exactly the same and was using literal values.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply