Viewing 15 posts - 4,591 through 4,605 (of 49,552 total)
Turn traceflag 1222 on. That will result in a deadlock graph being written to the error log.
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
October 6, 2015 at 11:07 pm
No.
If the procedure has been executed recently, and the plan is still in cache, then you can query sys.dm_exec_procedure_stats, but a procedure will only have an entry in there if...
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
October 6, 2015 at 1:11 pm
If you had restarted SQL, the rollback would have started again from the beginning, with the database offline and inaccessible until the rollback had completed. It's a good way to...
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
October 6, 2015 at 12:06 pm
Yes.
Though it's pretty useless to just say yes/no, as there are lots of caveats, limitations and considerations.
https://msdn.microsoft.com/en-za/library/ms191432.aspx
https://www.simple-talk.com/sql/learn-sql-server/sql-server-indexed-views-the-basics/
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
October 6, 2015 at 10:32 am
You can't put that into a loop. Do it the way you wrote in the second post, each variable explicitly assigned one by one.
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
October 6, 2015 at 10:23 am
Huh?
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
October 6, 2015 at 9:19 am
#gloat Company's paying for the trip to the US. If I was speaking at Pass Summit, they'd be paying for hotel too. They paid for my trip to the Cape...
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
October 6, 2015 at 9:15 am
What's wrong with it?
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
October 6, 2015 at 9:08 am
Ok, yeah, that's the plan compiling taking that time, assuming that it consistently takes 35 minutes run with recompile.
To be honest, not much you can really do. Maybe try to...
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
October 6, 2015 at 8:50 am
Are you sure it's the plan being cached that saves the time, and not the data being cached. Test with a warm data cache and the plan removed from cache,...
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
October 6, 2015 at 8:20 am
Markus (10/6/2015)
That just might be it.... when I look at her SPID SQL it shows the select... hum....
Yes, because the DMVs show the last statement that a session ran, 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
October 6, 2015 at 8:18 am
You could probably safely shrink it (once) to 175 or 200GB.
It can take a long time, but it's an online operation. I would recommend it be done out of main...
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
October 6, 2015 at 8:00 am
Unless she's starting a transaction and not committing (and making some form of data modifications in the transaction), closing the query tool is not necessary. In the absence of transactions,...
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
October 6, 2015 at 7:22 am
ps_vbdev (10/6/2015)
Your explanation makes total sense but where would the implicit conversation take place?
In your queries, if you're ever doing anything like
WHERE UserID = @ParameterOfTheUniqueidentifierType, or anything similar
And if...
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
October 6, 2015 at 6:54 am
Grant Fritchey (10/6/2015)
Unless they're starting a transaction and then walking away with it uncommitted.
Seen that happen before. Brought am entire application to a complete standstill on all users' machines.
If it...
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
October 6, 2015 at 6:35 am
Viewing 15 posts - 4,591 through 4,605 (of 49,552 total)