Viewing 15 posts - 11,971 through 11,985 (of 22,227 total)
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
There is something in 2008R2 called Master Data Services, but the strictures for using it were so severe we couldn't get it to fly within our environment. We went the...
"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 24, 2011 at 11:43 am
Welsh Corgi (8/24/2011)
I did not mean to offend you.I did not mean it that way.
No offence at all. I was joking. Sorry that came off harsh. It sure wasn't meant...
"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 24, 2011 at 11:42 am
Welsh Corgi (8/24/2011)
Grant Fritchey (8/22/2011)
Everyone at my old job thought I was weird when I picked up Kalen Delaney's SQL Server 2008 Internals and just started reading.
If they thought you...
"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 24, 2011 at 10:57 am
Oh yeah, it's going to block.
It's all about choices. You want to get rows back and not fall into the crack between a delete and an insert... gotta have the...
"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 24, 2011 at 10:56 am
You're trying to build an index off of a field or fields that is too large. You have to use less or smaller fields to build the index. There is...
"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 24, 2011 at 9:55 am
Robert Heynen-454800 (8/24/2011)
You mentioned a transaction earlier. 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
August 24, 2011 at 9:50 am
It's not at all unheard of to modify data, a lot, and query it at the same time. It's pretty standard in fact. But, you have set expectations and spend...
"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 24, 2011 at 8:42 am
Viewing 15 posts - 11,971 through 11,985 (of 22,227 total)