Viewing 15 posts - 4,186 through 4,200 (of 22,227 total)
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
You would have to make a call to xp_cmdshell. It's going to be more than a little sloppy. Why not reverse it. Create a Powershell command that calls to 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 1, 2016 at 5:43 am
joeroshan (12/1/2016)
Bruce-12445 (11/30/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 1, 2016 at 5:27 am
Everything Lowell says, plus check the system_health extended event session. It captures a whole bunch of behaviors, errors, etc., that aren't normally in the log. It could help identify 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
November 30, 2016 at 10:37 am
Just so you know, we're hosting SQL in the City as a streamed, live event this year. Check out my intro.
"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
November 30, 2016 at 10:35 am
John Mitchell-245523 (11/30/2016)
Grant Fritchey (11/30/2016)
I don't see any protection against SQL injection with this approach. I'd be a bit cautious about it. You don't want to meet Bobby Tables[/url].
There's no...
"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
November 30, 2016 at 7:26 am
I don't see any protection against SQL injection with this approach. I'd be a bit cautious about it. You don't want to meet Bobby Tables[/url].
"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
November 30, 2016 at 6:07 am
All the tool vendors will do this for you.
I work for Redgate software. I like our tool, SQL Monitor[/url]. It does all of what you're asking for and more. 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
November 30, 2016 at 6:04 am
Viewing 15 posts - 4,186 through 4,200 (of 22,227 total)