Viewing 15 posts - 1 through 15 (of 956 total)
A read-scale (or clusterless) Availability Group is for read scale out and not HA. There are very specific steps required to even use a read-scale AG for DR purposes:
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]
June 25, 2020 at 8:57 pm
Querying one of the DMVs requires access to resources. Reading the target state for an event session in the case of PREEMPTIVE_XE_GETTARGETSTATE and it's having to wait for that resource....
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]
June 19, 2017 at 7:59 am
Is it showing that wait type for it's own queries? Why do you think that it needs troubleshooting? Unless something changed with how Solarwinds collects it's data, it's constant polling...
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]
June 14, 2017 at 7:29 am
What monitoring tools are being used for the environment? I've seen this wait type happen frequently with DMV query execution, specifically often with sys.dm_exec_requests, and consider it to be a...
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]
June 14, 2017 at 6:58 am
And how exactly does an off topic tirade on a forum post that predates the feature you are advocating the use of by more than four years help change things?...
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]
January 1, 2016 at 7:17 am
You do realize you replied to a post that is 7 years old and completely predates SSISDB in SQL 2012?
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 31, 2015 at 7:29 pm
Duran (8/18/2015)
I'd love a bit of guidence in getting this cleared up. I'm not sure what way to turn as this point, and the box is critical. Obviously I am...
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 19, 2015 at 9:00 am
Tac11 (4/28/2015)
Msg 9436, Level 16, State 1, Line 7
XML parsing: line 5, character 15, end tag does not match start...
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 29, 2015 at 3:26 pm
AnthonyR (4/28/2015)
Tac11 (4/28/2015)
How do I delete previous deadlock report?
They're coming from a DMV (Dynamic Management View) so you cannot delete them, per se. All DMVs retain their data until either...
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 29, 2015 at 3:23 pm
SQLSentry Plan Explorer Pro already does this. You have to have a pro edition license though
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]
October 20, 2014 at 10:39 am
The deadlock XML from Extended Events in 2008/R2 is not compatible with SSMS being able to graphically display the deadlock graph.
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]
October 20, 2014 at 10:01 am
GilaMonster (12/23/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]
December 24, 2013 at 11:58 pm
I would recommend that you start off by doing a comprehensive read of the following two links:
http://www.sqlskills.com/blogs/kimberly/stored-procedure-parameters-giving-you-grief-in-a-multi-purpose-procedure/%5B/url%5D
http://www.sommarskog.se/dynamic_sql.html
Your nullable parameters are most likely a big part of the problem and this...
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 22, 2013 at 11:04 pm
GilaMonster (12/20/2013)
william.rees.howells (12/20/2013)
Well, if I use my load testing tool and load it up with about 20-30 concurrent queries running this SP then I can reliably recreate a load 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]
December 20, 2013 at 8:36 am
Other key considerations that factor into consolidation:
Security - do any apps have fixed server roles like sysadmin as requirements, those usually have to be segregated
Tempdb Usage - in a consolidated...
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 17, 2013 at 12:48 pm
Viewing 15 posts - 1 through 15 (of 956 total)