Viewing 15 posts - 11,956 through 11,970 (of 22,219 total)
SQLRNNR (8/25/2011)
GilaMonster (8/25/2011)
SQLRNNR (8/25/2011)
Grant Fritchey (8/25/2011)
... and Sharepoint and the business, and some PowerShell, and search engines, and a little NoSQL and...
Really, this is a public forum... We should...
"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
August 25, 2011 at 10:30 am
Sean Lange (8/25/2011)
Saga... (8/25/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
August 25, 2011 at 9:12 am
Ninja's_RGR'us (8/25/2011)
It depends.That's pretty much the only thing left to say atm!
:hehe:
+1
"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
August 25, 2011 at 9:10 am
GilaMonster (8/25/2011)
Tom.Thomson (8/25/2011)
I saw this in an SS Central topic, and responded appropriately - I hope. If anyone thionks I was inappropriately heavy, let me know.
Grrr. What a narrow-minded...
"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
August 25, 2011 at 9:06 am
Ninja's_RGR'us (8/25/2011)
sp_updatestats or update with fullscan IIRC they don't do the same thing?
100% accurate, they don't do the same thing. For most stats in most cases, the sampled scan, sp_updatestats...
"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
August 25, 2011 at 7:38 am
LutzM (8/25/2011)
do you really refer to the number of rows being returned?
Example: a query returning 100K rows should benefit from parallelism but the very same query expanded by a TOP...
"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
August 25, 2011 at 7:36 am
Ninja's_RGR'us (8/25/2011)
Grant Fritchey (8/25/2011)
Rajo (8/25/2011)
thanks for your replies.yes , i executed sys.dm_os_wait_stats and found the following has high wait time
CXPACKET
LAZYWRITER_SLEEP
SQLTRACE_BUFFER_FLUSH
SOS_SCHEDULER_YIELD
how to clear these wait types
thanks
CXPACKET waits are usually an indication...
"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
August 25, 2011 at 7:18 am
For every key press? Whoa! You might want to explore one of the NoSQL options to see if they can support you better. SQL Server is likely to barf 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
August 25, 2011 at 7:13 am
Ninja's_RGR'us (8/25/2011)
How did yo come up with that 10K suggestion?
Basically, wet my finger, stick it in the air, see which direction the wind is blowing...
I've seen benefits with larger data...
"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
August 25, 2011 at 7:12 am
Rajo (8/25/2011)
thanks for your replies.yes , i executed sys.dm_os_wait_stats and found the following has high wait time
CXPACKET
LAZYWRITER_SLEEP
SQLTRACE_BUFFER_FLUSH
SOS_SCHEDULER_YIELD
how to clear these wait types
thanks
CXPACKET waits are usually an indication of parallelism 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
August 25, 2011 at 7:09 am
Automatic update of statistics occurs as the data changes. After an update the stats will update as the indexes are accessed. If you're not seeing updated statistcs, those indexes haven'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
August 25, 2011 at 7:07 am
Did you start a transaction on the client side and is it committed?
"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
August 25, 2011 at 6:49 am
You have to monitor the server to identify what is running slow. As a quick and dirty start point, take a look at the wait states to see what things...
"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
August 25, 2011 at 6:48 am
Parallelism is not something that simply occurs in SQL Server. It's based on two things, the cost threshold you have set for parallelism. By default this value is 5. Personally,...
"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
August 25, 2011 at 6:45 am
Basically that's generating a "SELECT *" statement for every table that you define. Which means it selects everything, every time. It's just going to get slower and slower as 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
August 25, 2011 at 6:39 am
Viewing 15 posts - 11,956 through 11,970 (of 22,219 total)