Viewing 15 posts - 11,281 through 11,295 (of 22,219 total)
My first thought is, OMG that's thick.
I looked through it. Nothing jumped out as obviously out of line. I was able to run it through SQL Prompt for formatting, so...
"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
February 10, 2012 at 12:14 pm
To be sure you're capturing each transaction, the best bet would be to use a server-side trace. Here's an article[/url] that includes an introduction to 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
February 10, 2012 at 12:06 pm
David Benoit (2/10/2012)
sunny.tjk (2/10/2012)
I've the following events and no filtersSQL:BatchStarting
SQL:BatchCompleted
Audit Schema Object Access Event
Existing Connection
RPC completed
Audit Login
Audit Logout
Unless you are looking for connection information to be collected I would remove...
"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
February 10, 2012 at 12:04 pm
pdanes (2/10/2012)
Grant Fritchey (2/10/2012)
I just started working on an article on the backup header, ...
Yay! I'm almost completely out to lunch on the subject of backups. I've been doing a...
"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
February 10, 2012 at 9:09 am
Really depends on what's going on with the query. An inline table function is sort of like a permament CTE in that they're both just queries you're incorporating into your...
"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
February 10, 2012 at 7:06 am
Are you using dynamic management objects from 2008? Most of them are in 2005, so you can just reuse them.
SELECT * FROM sys.dm_os_performance_counters ;
for example, works in 2005.
"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
February 10, 2012 at 6:53 am
I'm a huge fan of Embarcadero's ERStudio. It's just an excellent piece of software. Yes, it generate the model straight off the database. You can also use it to design...
"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
February 10, 2012 at 6:51 am
If you're looking at an event, like sql batch completed, then the query that's in the text column is what generated the reads, writes, cpu and duration that are in...
"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
February 10, 2012 at 6:44 am
I just started working on an article on the backup header, so I can't point to it yet, but basically, the full backup has a marker for where it's 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
February 10, 2012 at 6:42 am
To my knowledge we don't do that.
Who is the spam from?
"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
February 9, 2012 at 8:32 am
richardm-1037631 (2/8/2012)
I really liked your statement "don't associate the log backups to the full or differential, but also, don't ignore them because of the full or differential." That hit...
"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
February 8, 2012 at 10:43 am
If you're looking for more, my chapter in the SQL Server MVP Deep Dives Volume 2[/url] book is all on parameter sniffing. (proceeds from the book go to charity in...
"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
February 8, 2012 at 8:53 am
richardm-1037631 (2/8/2012)
Thanks for the response. I've got 2 additional questions. Currently on my secondary server, sql server and sql agent are running as "Local System". Does this...
"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
February 8, 2012 at 8:14 am
richardm-1037631 (2/7/2012)
"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
February 8, 2012 at 6:20 am
Wait, you're running a full backup every two minutes? Is that right?
Assuming I'm reading that correctly, don't do that. If you want to be able to restore to a point...
"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
February 8, 2012 at 6:08 am
Viewing 15 posts - 11,281 through 11,295 (of 22,219 total)