Viewing 15 posts - 12,226 through 12,240 (of 22,227 total)
Ninja's_RGR'us (6/29/2011)
Satnam Singh (6/29/2011)
I will do post it. I was wondering it might be due to some constraints been missing on the tables.
That would potentially affect data quality, and very...
"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 8:09 am
Gianluca Sartori (6/29/2011)
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...
"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 8:07 am
calvo (6/29/2011)
Ninja's_RGR'us (6/29/2011)
... or upgrade sql express to sql express R2.
^^
Doesn't matter if it is standard, enterprise, or express, it's the same version number and that's all that matters. Now,...
"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:25 am
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
Viewing 15 posts - 12,226 through 12,240 (of 22,227 total)