Viewing 15 posts - 4,171 through 4,185 (of 22,219 total)
Oh here, let me help.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 15, 2016 at 2:37 am
So 36% of people thought that either: You don't need to compare them since the graphical plans are the same, which is blatantly false, or that You can compare the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 15, 2016 at 2:17 am
Is your database in Full recovery? If it is in Full recovery, are you running regular log backups? If not, you need to run backups, or you need to run...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 14, 2016 at 3:28 am
Stewart "Arturius" Campbell (12/13/2016)
That is a really neat addition to SSMS.However, still to be taken with a pinch of salt.
How do you mean? It's just comparing the underlying XML on...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 13, 2016 at 11:47 pm
The MDW itself puts too much load on a system. The overhead is not worth the benefits. That's the number one reason I'd recommend against it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 6, 2016 at 10:30 am
Jeff Moden (12/3/2016)
Grant Fritchey (12/2/2016)
Talib123 (12/2/2016)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 4, 2016 at 3:53 am
Availability Groups only support read only secondaries. Is QA a read only process or do they do writes? If they do writes, you can't use AG to solve this at...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 2, 2016 at 10:36 am
Talib123 (12/2/2016)
OK Grant, I might finally start looking @Extend Events.I have been avoiding it. Wish me luck.
Ha!
It's not that bad. Erin Stellato has a bunch of blog posts on getting...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 2, 2016 at 7:21 am
Talib123 (12/2/2016)
I would try the default trace, if your qucik enough you may get some information of what caused the files to grow and at what time.
The system_health extended event...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 2, 2016 at 6:48 am
Jeff Moden (12/1/2016)
Grant Fritchey (12/1/2016)
It's going to be more than a little sloppy.Not sure why anyone would say such a thing. What kind of "slop" are you taking about?
Running...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 2, 2016 at 6:36 am
Jeff Moden (12/1/2016)
Eric M Russell (12/1/2016)
Jeff Moden (12/1/2016)
Benki Chendu (11/29/2016)
I have used Microsoft SCOM, HP Openview, BMC Patrol and a few more tools to monitor my database infrastructure..But currently, I...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 2, 2016 at 6:17 am
One wrinkle I would add, however you build the deployment, SSIS or Powershell (I'd lean to Powershell personally), have that process create a script from the collection of ad hoc...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 1, 2016 at 7:42 am
Might be a little confusion there. EXEC 'some query' is very easily hacked. What Gail teaches in that article is not.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 1, 2016 at 5:50 am
But if you are asking about a SQL Server 2016 instance in the 2008 forum, if people here are not running 2016, as many are not, you're not going to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 1, 2016 at 5:48 am
If you want the trace to stop at a specific time. If you don't care if it runs forever, don't bother stopping it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 1, 2016 at 5:45 am
Viewing 15 posts - 4,171 through 4,185 (of 22,219 total)