Viewing 15 posts - 12,226 through 12,240 (of 22,224 total)
It could be resource contention, blocking, statistics... hard to know without more information. First, check for blocking. Run a quick query against sys.dm_exec_requests. That will tell you if your process...
"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 29, 2011 at 6:22 am
Without more information, it's hard to know. OK, the database was in recovering mode. Fine. Were there transactions being run against it when it shut down? What was the status...
"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 29, 2011 at 5:28 am
Koen Verbeeck (6/28/2011)
Grant Fritchey (6/28/2011)
First person I know to get one. Well done!
Thanks!
I started at a new client today, and when I first logged into my new development station, I...
"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 28, 2011 at 2:06 pm
Koen Verbeeck (6/28/2011)
Chad Crawford (6/28/2011)
Wahoo! My users group just scheduled me to speak in August. Let the stress begin.... 😀
Congratulations.
I did my very first technical session last...
"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 28, 2011 at 1:40 pm
Chad Crawford (6/28/2011)
Wahoo! My users group just scheduled me to speak in August. Let the stress begin.... 😀
Congrats. Have fun. Don't get stressed. If you're not having...
"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 28, 2011 at 11:17 am
Gianluca Sartori (6/28/2011)
Yeah! 3000 points for me!It's a small step for most of you, it's a great step for me.
Well done. Thanks for all your work.
"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 28, 2011 at 6:24 am
oluwaseunadenaike (6/28/2011)
I guess SQL profiler and the DB tuning advisor are my best bets .... what types of common performance bottlenecks should i look out for...
"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 28, 2011 at 5:13 am
Pretty much everything. Did you get no turnover from the previous DBA or your manager? If not, you're in a tough spot.
Backups and disaster recovery should be your primary concerns....
"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 28, 2011 at 4:29 am
You need to go into SCOM itself and look at how it's collecting data from that server. From the sounds of things you have it configured to only pull 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
June 28, 2011 at 4:25 am
yasubmj (6/27/2011)
Thanks Grant, i see the point. Any suggestions as to how i can solve this?
Filter the data in some fashion is the best answer I have. Assuming the selectivity...
"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 28, 2011 at 4:19 am
Ninja's_RGR'us (6/27/2011)
Grant Fritchey (6/27/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 27, 2011 at 5:33 am
It really depends on the volatility of the data, the structure of the indexes, and the types of queries run against it. We updated statistics on an insurance system I...
"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 27, 2011 at 5:12 am
You're retrieving 261000 rows out of a table that has 268000 unique values (not sure if that's how many rows it has or not). I'm a little surprised that it's...
"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 27, 2011 at 5:07 am
Many of the maintenance tasks you're doing can be logged operations. That would explain the increased log backup size.
Why, oh why are you shrinking the database? That is, in 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
June 27, 2011 at 4:54 am
Recovery means it is checking its integrity and rolling back/forward transactions that were open when it was shut down. There's no way to know for sure how long it will...
"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 27, 2011 at 4:52 am
Viewing 15 posts - 12,226 through 12,240 (of 22,224 total)