Viewing 15 posts - 12,301 through 12,315 (of 22,219 total)
Stefan Krzywicki (6/14/2011)
Grant Fritchey (6/14/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
June 14, 2011 at 12:31 pm
Perfmon is extremely lightweight if you're capturing the data out to a file other than the OS drive or on of the data or log drives for the database. If...
"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
June 14, 2011 at 12:03 pm
Oh yes, there's a whole elite level of forums where we actually post only real answers instead of the usual pile of... oh my god... ninjas... arggghhhh!!!!
Nothing to see here....
"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
June 14, 2011 at 10:39 am
I wouldn't get too hung on trying to correlate the two, but the events are showing pages read. A 1 is one page. 2, etc. are more pages. I don't...
"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
June 14, 2011 at 10:37 am
Profiler is for viewing the results of and defining server side traces. You can also run it directly against a database to capture data, but I don't recommend it.
It's primary...
"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
June 14, 2011 at 10:27 am
opc.three (6/14/2011)
The StatementSetOptions in the XML are apparently wrong per this bug report:
The bug report is for one of the 2008 CTPs but the bug is there in my...
"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
June 14, 2011 at 10:24 am
Yep, that would do it.
You may also have to drop individual database users as well, especially if that login created objects out on the databases with itself as owner.
"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
June 14, 2011 at 9:41 am
So, do I understand correctly, the shutdown was taking a long time or was hung? Did you just power off? Sounds like it was trying to deal with an open...
"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
June 14, 2011 at 9:40 am
Was the reboot in response to a problem or was it a clean shut down because of a service pack or something? If you shut down because of a hung...
"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
June 14, 2011 at 8:29 am
Without seeing both execution plans, we're just guessing.
Let's speculate for a moment. Maybe, you're getting timeouts on the optimizer. Adding a nonclustered index changed the order in which plans were...
"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
June 14, 2011 at 7:31 am
Gail & Gus have largely addressed everything. Only thing I'll add is if you want details on configuring tempdb go by Paul Randal's blog sqlskills.com. He has several excellent articles...
"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
June 14, 2011 at 7:04 am
The load on tempdb absolutely increases. You have to be sure that you have that configured correctly and that you can support more space in tempdb. Other than that, 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
June 14, 2011 at 6:09 am
Sorry, I didn't see this question (still can't get the RSS feed to work for this topic). I've been doing lots of experimentation with SQL Azure, as Steve pointed out....
"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
June 14, 2011 at 5:59 am
For really small sets of data, no, you won't see much of an improvement. But as you start stuffing more keys on a page for an index, you will see...
"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
June 14, 2011 at 5:11 am
Alphabetically 'S' is greater than 'C'
If you think you're comparing the lengths of the strings, you're not. You need to use LEN to see the number of characters or DATALENGTH...
"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
June 14, 2011 at 5:01 am
Viewing 15 posts - 12,301 through 12,315 (of 22,219 total)