Viewing 15 posts - 2,281 through 2,295 (of 49,552 total)
For that database?
What else is in the error log before that Recovering message?
For a DB to be going into recovery often, it would either have autoclose enabled (and hence recovering...
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 4, 2016 at 3:48 am
File size and growth changes are immediate, no restarts are needed.
How are you checking the growths and how are you setting 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
October 4, 2016 at 3:29 am
Is AutoClose enabled?
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 4, 2016 at 3:28 am
If you need to change the default recursion for CTEs, you need to use maxrecursion. Either work with your DBA so that he sees why you need it, or re-design...
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 3, 2016 at 10:09 am
Other option for what?
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 3, 2016 at 9:56 am
Everyone's an expert. 🙁 http://www.sqlservercentral.com/Forums/Topic1822300-263-1.aspx
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 3, 2016 at 8:27 am
Hmm... Odd.
How large are the XML columns being returned by that query? (use the DataLength() function)
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 3, 2016 at 3:44 am
robert.sterbal 56890 (9/30/2016)
I'm on endless conference calls that would work as a recording.
Which is what Virtual Chapters do (online meeting software rather than conference calls, but similar enough), and why...
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 3, 2016 at 3:19 am
Can you post the execution plan please?
p.s. Are you sure you want the potentially missing and duplicate rows that nolock allows?
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 3, 2016 at 3:11 am
WayneS (9/30/2016)
Oh, what a fun day this is turning out to be. (Check out the attachment)
Whaaaaaa???
How many sessions involved there?
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
September 30, 2016 at 3:08 pm
Yes, you'll be fragmenting the indexes which will require you to rebuild them all (which will grow the file again)
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
September 30, 2016 at 10:35 am
You can reduce the file size, but backups don't contain empty space, so shrinking is not going to reduce your backup size.
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
September 30, 2016 at 8:52 am
You can script the DB, export the data and recreate the DB on SQL 2008, or you can upgrade the 2008 server to 2012, but that's about your only options.
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
September 30, 2016 at 8:31 am
Can't see the size of the VLFs there, but looks like the last one starts just before 500MB and ends, I would guess, at the 534 the log shrunk 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
September 30, 2016 at 7:48 am
The first couple of rows of LogInfo is kinda useless when the problem is at the end of the file...
Could be that the VLF sizes are such that it can't...
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
September 30, 2016 at 7:16 am
Viewing 15 posts - 2,281 through 2,295 (of 49,552 total)