Viewing 15 posts - 20,281 through 20,295 (of 49,552 total)
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
February 16, 2012 at 3:44 am
chewychewy (2/16/2012)
For eg, my PLE is 300. So does it means that one page of the above will flush out every 5 mins to make space for new page?
No, 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
February 16, 2012 at 3:43 am
newkidd (2/15/2012)
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
February 16, 2012 at 1:59 am
Those errors are not fixable, and I told you how to proceed
The only solution now is to recreate the database. Script all of the objects in the DB, export all...
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
February 16, 2012 at 1:55 am
Please read the first article again and look at the section on replication waits. It links to a blog post as well. Read that.
Switching to full recovery just makes 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
February 16, 2012 at 1:54 am
Nothing's flushed. Flushing the cache every 5 minutes would be silly.
PLE is the average time that a page will remain in cache before been removed for whatever reason. So 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
February 16, 2012 at 1:52 am
ScottPletcher (2/15/2012)
I wouldn't call it 'auto-magically',
That's primarily what I meant. I thought it was conditional. I've seen SQL not do it.
To me it's much safer to code...
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
February 16, 2012 at 1:51 am
The backup will be striped equally across all files.
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
February 16, 2012 at 1:49 am
It's just the default. No real advantage for files.
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
February 16, 2012 at 1:48 am
Open up Books Online (the SQL help file/manual) and read over the page ALTER 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
February 15, 2012 at 4:01 pm
ScottPletcher (2/15/2012)
IIRC, a single insert of many rows will be done in the clustered index order auto-magically.
Really? Interesting. I don't recall that. Would be nice tho.
Yup, does...
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
February 15, 2012 at 3:55 pm
It could well be setting the deadlock priority implicitly based on the amount that need to be rolled back if the user hasn't explicitly set one already. Alter Index Reorganise...
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
February 15, 2012 at 3:46 pm
The one that will be the least work to roll back will be the victim, basically the one that's logged the least changes in the current transaction.
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
February 15, 2012 at 3:12 pm
Index fragmentation != file fragmentation. If running a file system defrag tool on SQL databases, SQL Server must be stopped for the duration. While there are tools that claim they...
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
February 15, 2012 at 3:11 pm
Just rebuild the clustered index, there's no need to drop anything and having the nonclustered indexes won't make the clustered index rebuild longer or make it do more.
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
February 15, 2012 at 1:49 pm
Viewing 15 posts - 20,281 through 20,295 (of 49,552 total)