Viewing 15 posts - 11,386 through 11,400 (of 22,224 total)
And if writing a book carries weight (I'd argue it doesn't, but...) then I do have a book about the Profiler and I also argue for using the server-side trace...
"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
January 19, 2012 at 10:00 am
I strongly recommend setting the log to that larger size and leaving it there. Shrinking it over & over and letting it auto-grow over & over, that's causing fragmentation and...
"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
January 19, 2012 at 7:15 am
You can change the compatibility level with connections in place. But according to the Books Online, if you do that, you could get incorrect results in queries or other odd...
"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
January 19, 2012 at 7:12 am
Performance tuning is hard. It's difficult and it's time consuming and no, there are no reliable and accurate shortcuts.
You can fix some simple stuff by running software like SQL Cop...
"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
January 19, 2012 at 7:01 am
There are legitimate practice tests you can take. Check the Microsoft web site. They list them there.
"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
January 19, 2012 at 6:57 am
Brandie Tarvin (1/19/2012)
I am beyond thrilled...
"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
January 19, 2012 at 5:52 am
SQLRNNR (1/18/2012)
L' Eomot Inversé (1/18/2012)
SQLRNNR (1/18/2012)
I have been able 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
January 18, 2012 at 5:47 pm
TravisDBA (1/18/2012)
Grant Fritchey (1/18/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
January 18, 2012 at 3:38 pm
The thing is, you can still use Profiler with all the cool stuff it does for you. It can generate TSQL for you to output trace events to a file,...
"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
January 18, 2012 at 3:21 pm
TravisDBA (1/18/2012)
TravisDBA (1/18/2012)
Dave Ballantyne (1/18/2012)
I still say that using SQL Profiler is a good place to start
It hasnt been said explicity in this thread , so i will 🙂
Never...
"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
January 18, 2012 at 3:04 pm
I would set up an extended events session to capture the queries being executed on the server. I would also start monitoring the server using Performance Monitor.
You need 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
January 18, 2012 at 8:52 am
Cadavre (1/18/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
January 18, 2012 at 8:13 am
Jan Van der Eecken (1/18/2012)
Jack Corbett (1/18/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
January 18, 2012 at 7:24 am
Nope, no query that I saw either.
"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
January 18, 2012 at 4:35 am
You have to understand where the split occurs between what's useful to monitor and what's not. Memory & CPU monitoring is now different. You're not going to want to look...
"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
January 18, 2012 at 4:32 am
Viewing 15 posts - 11,386 through 11,400 (of 22,224 total)