Viewing 15 posts - 21,421 through 21,435 (of 49,552 total)
Ninja's_RGR'us (1/3/2012)
Yes, read the book!She's not lazy, it's not something she can answer in 2 words.
Just to put things in perspective, the chapter that I'm referring you to is 28...
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
January 3, 2012 at 9:43 am
Duran (1/3/2012)
Do you have any advice in this area?
Yes. Set a sensible max server memory. What's sensible, well, that depends on the OS, the amount of memory in the server...
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
January 3, 2012 at 9:41 am
hkamal.infoedge (1/3/2012)
Switch the full recovery mode to simple recovery mode and then switch back to full mode and take the full back up.
No, no, no, no, no!
And on a day...
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
January 3, 2012 at 9:39 am
Duran (1/3/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
January 3, 2012 at 8:46 am
Dev (1/3/2012)
PS. OS consumes 2 GB of RAM.
Err, no.
2GB is the default size of the kernel portion of VAS on 32-bit servers, not the amount of memory 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
January 3, 2012 at 8:41 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1229298-364-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
January 3, 2012 at 8:36 am
kapfundestanley (1/3/2012)
What would you recommend as the ideal back-up strategy for SQL Server?
There's no one answer to that. It depends on the size of the DB, your backup windows, your...
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
January 3, 2012 at 7:45 am
Dev (1/3/2012)
SQL Server will consume the memory specified in MIN memory configuration at start up.
No, it does not. Min server memory is that value that once allocated SQL...
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
January 3, 2012 at 7:36 am
Duran (1/3/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
January 3, 2012 at 7:35 am
johnitech.itech (1/3/2012)
:hehe:Optimize SQL Server 2000, 2005 or 2008 in Large RAM System by Locking Pages in Memory and AWE
AWE is useless on 64-bit SQL
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
January 3, 2012 at 7:31 am
yo_jain (1/3/2012)
Hi,Is that correct that Table Partitioning will be available in Sql server Developer and Enterprise Edition only ?
Yup. Enterprise only
Can you guide me by providing some step by step...
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
January 3, 2012 at 6:42 am
okbangas (1/3/2012)
Personally, I've never had any problems with having lock pages in memory configured
I've had a server crash (and it was a mission critical, etc) because locked pages was 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
January 3, 2012 at 6:37 am
Dev (1/3/2012)
The problem I see here is, there are two groups of MVPs supporting different opinions (On/Off).
Nothing wrong with that. If everyone was a robot parroting 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
January 3, 2012 at 6:35 am
MysteryJimbo (1/3/2012)
Personally, I like to have it enabled as I've previously been stung in the past
Likewise, but it's not an automatic decision.
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
January 3, 2012 at 5:43 am
The eval version is 180 days, so look at the date of the setup logs (which will be the date of installation) and calculate 180 days from 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
January 3, 2012 at 5:42 am
Viewing 15 posts - 21,421 through 21,435 (of 49,552 total)