Viewing 15 posts - 16 through 30 (of 964 total)
PFlorenzano-641896 (12/11/2013)
http://www.sqlservercentral.com/articles/autogrowth/93229/
The ONLY difference is that I'm attempting to use an existing database during the Testing Event...
December 11, 2013 at 2:16 pm
PFlorenzano-641896 (12/11/2013)
Thank you for providing this article. I have a question on how to add this functionality to an 'existing' database within my organization.
For instance, the code you...
December 11, 2013 at 1:57 pm
The 'optimize for adhoc workloads' sp_configure option only affects the adhoc cache, so all of the other caches will still keep the full plan for single use executions, which is...
November 14, 2013 at 9:38 pm
It depends, and without a lot of added information I can't say for sure. You previously said that buffer pool was only using 51GB after the patch so you...
November 14, 2013 at 9:04 pm
SQLDBAPerth (11/14/2013)
November 14, 2013 at 7:19 pm
TheSQLGuru (11/14/2013)
November 14, 2013 at 11:00 am
The condition you describe fits the SQLOS memory manager bug that is fixed in CU4 (http://support.microsoft.com/kb/2845380) but if you are going to take an outage to apply CU4,...
November 13, 2013 at 9:34 am
The size of the working set here is very small and this is not likely a real problem. See the update on this blog post that states this could...
August 26, 2013 at 11:08 am
nellimarlakiran (4/19/2013)
What is the impact on server when we are using extended events.CPU pressure ?
IO issues ?
It depends on the events being collected, the workload, and what targets are...
April 19, 2013 at 11:11 am
kevaburg (3/18/2013)
Nonetheless, the book has picqued my interest.....now I'm off to Amazon...... 😀
You can get a free copy in PDF format from Redgate's website if you want to...
March 18, 2013 at 6:27 am
nelsonaloor (3/17/2013)
March 17, 2013 at 8:06 pm
Pages 144-145 of the book Gail recommended provides a general initial configuration recommendation that is designed to be safe for dedicated SQL Servers, but it also makes specific recommendations for...
March 17, 2013 at 2:18 pm
Empty post, I made a mistake in my thinking about something here.
March 15, 2013 at 3:48 pm
Pull the cover on the Dev box and look at where the RDIMMs are located and see if they are all populated on one socket or balanced across both of...
March 15, 2013 at 3:34 pm
cryovenom (3/15/2013)
Then, for fun, it drives the point home with an exaggerated comparison and copious amounts of exclamation marks.
It actually isn't an exaggerated comparison at all. My Dell Precision...
March 15, 2013 at 3:00 pm
Viewing 15 posts - 16 through 30 (of 964 total)