Viewing 15 posts - 8,776 through 8,790 (of 49,552 total)
smtzac (6/10/2014)
My question is IN MY SITUATION what's the 'desirable size' would be? another word what size should I give to log file after above process?
The max amount of space...
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 10, 2014 at 9:24 am
Whether it's feasible or not depends on whether it meets your RTO and RPO requirements. I can't answer that.
Adding diffs every 4 hours to your current strategy will reduce 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
June 10, 2014 at 8:04 am
When do you want to run the diffs?
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 10, 2014 at 7:49 am
You restored the full backup WITH RECOVERY (the default), hence SQL recovered the database and brought it online at the end of the restore, allowing no further backups to be...
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 10, 2014 at 7:46 am
Andrew Kernodle (6/10/2014)
... *Facepalm* Yep, it certainly does.
So writers don't block readers, instead the read query fetches the previous version out of the version store. The update...
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 10, 2014 at 7:43 am
SQLRNNR (6/10/2014)
Gailforgotwas too lazy tomentionlook up the URL for her blog post on the topic while at 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 10, 2014 at 7:42 am
dax.latchford (6/10/2014)
Also what would be a 'Best Practice' approach to shrink the log file?
I thought I already answered that. If you have regular log backups running, then do a once-off...
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 10, 2014 at 7:29 am
dax.latchford (6/10/2014)
(1) Change the Recovery mode from Full to Simple
(2) Run a backup against the DB
(3) Check the location 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
June 10, 2014 at 7:17 am
Jeff Moden (6/10/2014)
That's not what I've heard, though.
Maybe spend some time with Kalen's whitepaper? Lots of people have said lots of garbage about Hekaton.
I've heard terms such as "Delayed Durability"...
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 10, 2014 at 7:03 am
Jeff Moden (6/10/2014)
Grant Fritchey (6/9/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 10, 2014 at 6:21 am
wall str33t (6/9/2014)
In clauses are generally slower because people write them instead of joins,
Are you sure about that? Got some reproducible examples which show that 'ins are generally slower than...
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 10, 2014 at 4:45 am
To start with... https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/
That should guide you through identifying and fixing most deadlocks. They do have to be investigated and fixed one by one, there's no magic switch 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 10, 2014 at 4:37 am
Sure, why wouldn't it be?
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 10, 2014 at 3:47 am
Was there another line in the message which you didn't post?
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 10, 2014 at 3:47 am
And it was the entire output, no extra lines that you didn't post?
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 10, 2014 at 3:40 am
Viewing 15 posts - 8,776 through 8,790 (of 49,552 total)