Viewing 15 posts - 11,341 through 11,355 (of 49,552 total)
You generally don't want to rebuild small indexes because it's a waste of time, fragmentation doesn't cause problems with small indexes. The rough threshold I usually hear is somewhere around...
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 10, 2013 at 7:13 am
Ryan007 (10/10/2013)
Do you recommend to set memory limit to a lower value in this case?
Always. I really don't like SQL and the OS fighting over memory (which they will do...
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 10, 2013 at 7:10 am
Err.. where?
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 10, 2013 at 7:07 am
Brandie Tarvin (10/10/2013)
GilaMonster (10/9/2013)
Brandie, do you have any writing tools that you'd recommend, for tracking characters, places, plot segments, stuff like that? Preferably for iPad and PC.
I use StoryBox for...
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 10, 2013 at 6:48 am
dwain.c (10/9/2013)
http://www.sqlservercentral.com/Forums/FindPost1503017.aspx
I used to teach 2 methods to swap A and B in entry level university FORTRAN course (too)...
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 10, 2013 at 6:45 am
SQL is supposed to consume memory, that's how it's designed. If you don't want SQL to take all the memory on the server, set max server memory and that will...
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 10, 2013 at 6:38 am
Brandie, do you have any writing tools that you'd recommend, for tracking characters, places, plot segments, stuff like that? Preferably for iPad and PC.
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 9, 2013 at 2:29 pm
The latest errorlog, not the latest job failure.
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 9, 2013 at 2:06 pm
60ms isn't bad. Not perfect, but way better than I've seen in many cases.
If you're seeing IO bottleneck on TempDB, splitting the user DB into multiple files isn't going 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 9, 2013 at 2:01 pm
Can you post the latest 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 9, 2013 at 1:59 pm
Custom functions in master would show master as the source.
Post the deadlock graph? I'd guess there's some built-in function or procedure involved (those are stored in the resource DB)
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 9, 2013 at 1:58 pm
Got a job somewhere changing recovery models? Perhaps after the full backup?
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 9, 2013 at 12:38 pm
Ask them how they know that.
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 9, 2013 at 9:48 am
First question, why are you splitting it, recoverability or performance? If performance, have you checked whether the current bottleneck is IO?
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 9, 2013 at 9:30 am
If it was CTP it would say CTP in @@version.
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 9, 2013 at 9:13 am
Viewing 15 posts - 11,341 through 11,355 (of 49,552 total)