Viewing 15 posts - 4,906 through 4,920 (of 49,552 total)
We can't tune it if we can't see it.
If you can;'t post it, then you're going to have to rewrite it yourself into the form of an in-line table valued...
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
August 27, 2015 at 6:44 am
JaybeeSQL (8/27/2015)
Should the system databases be best moved in any particular order?
To be honest, other than TempDB, I'd probably leave the others alone for now. Moving master is not the...
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
August 27, 2015 at 5:04 am
Pro-active performance monitoring. Not 'what's slow right now', but rather trends and historical data. What was procedure x performing like last week compared with today. Wait stats and IO stats...
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
August 27, 2015 at 5:02 am
Restore from your last good backup (plus log backups)
Repair is usually a last resort for when you don't have backups.
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
August 27, 2015 at 4:19 am
Same effects as if you were using it without snapshot turned on. Duplicate reads, missing rows, dirty reads and this time for no gain at all because under RCSI readers...
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
August 27, 2015 at 4:15 am
You're summing the CPU up over the 6 hours. In total, over 6 hour real period, that query did a total of 135 hours of CPU time, easy enough 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
August 27, 2015 at 4:09 am
Since it's an indexed view, giving us the definition of the view is useless from the point of tuning. You need to identify the queries using the view that are...
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
August 27, 2015 at 4:07 am
Round it to what?
7.84 should become:
8?
7.8?
7.84?
7.840?
Something else?
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
August 26, 2015 at 3:05 pm
Robert W Marda (8/26/2015)
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
August 26, 2015 at 1:26 pm
What you're asking for would complicate the lock manager massively, it would also break the isolation (and probably consistency) guarantees which SQL has to provide.
If a deadlock victim, instead of...
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
August 26, 2015 at 12:19 pm
mitzyturbo (8/26/2015)
It is performing an index seek though oddly enough.
With the query you posted and the two indexes you posted, there is no way that SQL can perform an index...
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
August 26, 2015 at 11:46 am
No.
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
August 26, 2015 at 11:42 am
I do. All my colleagues and clients, whose machines I end up working on from time to time while helping/consulting, not so much.
And you've changed snippets. de <space> gets me...
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
August 26, 2015 at 8:09 am
That would be a far better question, because there's no SQL command to add drives to a server. 😉
Firstly, you don't want to move the binaries, as that would require...
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
August 26, 2015 at 8:00 am
Gazareth (8/26/2015)
But probably the most common: DELCARE left left left backspace left C 😛
In that case, mine would be SEELCT left left backspace left L :hehe:
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
August 26, 2015 at 7:26 am
Viewing 15 posts - 4,906 through 4,920 (of 49,552 total)