Viewing 15 posts - 8,611 through 8,625 (of 49,552 total)
What statement does it hang on?
What does that statement do?
If you run that statement separately, what happens?
Is it waiting for a file?
What are the wait types involved?
What state is that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 26, 2014 at 7:22 am
Oooh, another case for the crystal ball. Or maybe the magic 8-ball...
http://www.sqlservercentral.com/Forums/Topic1586405-2799-1.aspx
Magic 8-ball says "unknown"
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 26, 2014 at 7:20 am
GilaMonster (6/26/2014)
Ad-hoc queries have neither an object ID or database ID associated with them.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 26, 2014 at 7:08 am
cross apply that DMV to sys.dm_exec_sql_text, that DMV has the objectID and database (for procedures), you can join that to sys.objects/sys.procedures.
Ad-hoc queries have neither an object ID or database ID...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 26, 2014 at 6:51 am
Backup, copy, restore can work. You can restore as a different name then swap the old and new databases very quickly.
Log shipping will result in a read-only database at...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 26, 2014 at 6:49 am
Please post table definitions, easily usable sample data and expected results, as per http://www.sqlservercentral.com/articles/Best+Practices/61537/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 26, 2014 at 3:48 am
Evil Kraig F (6/25/2014)
I can't seem to find my favorite image of a crystal ball with the matrix code running down through it, otherwise I'd throw it in.
If you can...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 26, 2014 at 2:33 am
Take a read through these:
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 26, 2014 at 2:30 am
Koen Verbeeck (6/25/2014)
Sarah Wagner (6/25/2014)
Thank you Craig Farrell for making my afternoon with "I left my crystal ball in my other pants."
To be honest, Craig stole it from me when...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 25, 2014 at 3:08 pm
jcrawf02 (6/25/2014)
Ed Wagner (6/25/2014)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 25, 2014 at 2:29 pm
You need either a time machine or some existing, custom auditing for logins to have been in place for a year.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 25, 2014 at 1:52 pm
GilaMonster (6/25/2014)
The blocked process threshold is not going to catch deadlocks.
So, which are you trying to do? Catch long-lasting blocking scenarios (for which the blocked process report will work)...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 25, 2014 at 6:07 am
Please post new questions in a new thread. Thank you.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 25, 2014 at 4:33 am
Selects don't block selects, so the queries you ran shouldn't have triggered a blocked process report, they wouldn't have blocked each other.
What are you trying to do, detect deadlocks or...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 25, 2014 at 4:13 am
PearlJammer1 (6/25/2014)
Would you say they are high given the numbers I mentioned ?
You're the only one who can say if they're high, because 'high' is a sustained value over what's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 25, 2014 at 4:01 am
Viewing 15 posts - 8,611 through 8,625 (of 49,552 total)