Viewing 15 posts - 16 through 30 (of 956 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 Notification instead...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
November 14, 2013 at 9:04 pm
SQLDBAPerth (11/14/2013)
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
November 14, 2013 at 7:19 pm
TheSQLGuru (11/14/2013)
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
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, I would...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
March 18, 2013 at 6:27 am
nelsonaloor (3/17/2013)
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
March 17, 2013 at 2:18 pm
Empty post, I made a mistake in my thinking about something here.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
March 15, 2013 at 3:00 pm
Viewing 15 posts - 16 through 30 (of 956 total)