Viewing 15 posts - 12,766 through 12,780 (of 22,227 total)
ChrisM@home (4/13/2011)
CirquedeSQLeil (4/13/2011)
Grant Fritchey (4/13/2011)
Teh Gila Monster has teh big scares on me and makes me afeared fer me woefully inadequate sexual equipment.*cough*
That should help.
Don't you have to turn 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
April 13, 2011 at 12:15 pm
ChrisM@home (4/13/2011)
Grant Fritchey (4/13/2011)
ChrisM@home (4/13/2011)
varun.dubey29 (4/13/2011)
"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
April 13, 2011 at 12:14 pm
Timothy Straub (4/13/2011)
Thanks for the info and yes I am testing the performance of a query. I was hoping to be able to test a separate DB...
"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
April 13, 2011 at 10:06 am
CirquedeSQLeil (4/13/2011)
How many of you would walk out on a job without completing it (as a contractor/consultant) - if you were getting paid?
Hard one to answer. Unless there was 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
April 13, 2011 at 10:04 am
Stack overflow is pretty good too.
"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
April 13, 2011 at 9:12 am
It's going after the instance. Why would you do that?
I mean, for testing purposes, fine, but I wouldn't suggest running that in production.
"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
April 13, 2011 at 9:11 am
After the fact, when everything is done, without a trace file available? You can't. If you have a trace running, you can use that to get the user (assuming you're...
"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
April 13, 2011 at 9:10 am
Patrick_Fiedler (4/13/2011)
You can take the following statement:
selectcntr_value as [PageLifeExpectancyInSeconds]
fromsys.dm_os_performance_counters
whereobject_name like '%:Buffer Manager%'
and counter_name like 'Page life expectancy%'
If the value falls below...
"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
April 13, 2011 at 6:19 am
ChrisM@home (4/13/2011)
varun.dubey29 (4/13/2011)
"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
April 13, 2011 at 6:12 am
First thing I'd do is bump the cost threshold for parallelism up to a much higher number. The default of 5 is ridiculously low. Start at 30 and then adjust...
"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
April 13, 2011 at 6:00 am
On first glance, it looks like you're swapping stuff out of memory a lot. I'd focus where I usually find myself focusing, the queries. Use a server-side trace to get...
"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
April 13, 2011 at 5:56 am
I left a company that split the duties between development and administration. Further, administration was split between operations and systems. The systems guys literally built servers, clusters, virtuals, and managed...
"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
April 13, 2011 at 5:53 am
If you didn't get errors when you created the index, it's there, and "kicked in." Now, whether or not it's getting used, well, there's used and there's used. As was...
"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
April 13, 2011 at 5:49 am
Have you tried it? Is it not working or are you getting an error?
"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
April 13, 2011 at 5:46 am
I was just trying to type Page Life Expectancy but Craig beat me to it. It's one of the best indicators for memory pressure.
Also, you should monitor the wait...
"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
April 13, 2011 at 5:43 am
Viewing 15 posts - 12,766 through 12,780 (of 22,227 total)