Viewing 15 posts - 16,951 through 16,965 (of 22,226 total)
It's hard to make suggestions without seeing the query and an actual execution plan. Can you post those? Also, in case people need to experiment it's useful to post 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
July 22, 2009 at 6:11 am
I'd suggest using sys.dm_tran_locks instead of the old method. You can get much more granular information and combine the output with other views to get a great deal more information.
"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
July 22, 2009 at 6:08 am
Nothing. I'm an idiot. Sorry, I just misread your question.
No, I don't usually see perfmon miss data, but it's possible. How much are you trying to collect and how frequently...
"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
July 22, 2009 at 6:02 am
The transaction log can fill from transactions, regardless of the recovery mode, although some recovery modes are less likely to fill the log than others. You need to keep that...
"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
July 22, 2009 at 5:55 am
What do you mean by a "forced" database backup?
"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
July 22, 2009 at 5:52 am
. (7/21/2009)
What kind of roleplaying game involves conspiracies, Gail?fnord
Call of Cthulhu. It's all a conspiracy. The Elder Gods. He Who Sleeps. The Crawling Chaos. Ia Ia, Cthulhu Fhtagn!
"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
July 22, 2009 at 5:28 am
Yeah, I'd pay postage on stuff you want to get rid of as well. Post the list. We'll make claims.
"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
July 21, 2009 at 12:20 pm
You've got a mixed set of ANSI & non-ANSI joins (some are "tableA, tableB" and some are "TableA JOIN TableB ON"). First thing I'd do is make them all ANSI...
"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
July 21, 2009 at 11:15 am
Yeah, Lynn has it right. That's not a good thing. Not only should you do what he said, but I'd review the other eight indexes. See if there are duplications...
"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
July 21, 2009 at 11:11 am
I'm not sure if Steve can move just the question or not. Just repost it. However, what I said still applies. Wait states are what will tell you the cause...
"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
July 21, 2009 at 8:38 am
Don't just compare query times or CPU load, look at the wait states. What are processes waiting on inside the system. That will tell you where the bottleneck 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
July 21, 2009 at 8:25 am
Matt's advice is definitely good.
Here's a local article: http://www.sqlservercentral.com/articles/Administration/performancemonitoringbasiccounters/1348/%5B/url%5D
There are others. Just do a search in the box at the top of the screen.
I don't usually try to plug...
"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
July 21, 2009 at 6:57 am
You could run a query using sp_who2 to see who's connected. You can also click on the Activity Monitor icon, which will open the activity monitor and show who's connected.
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
July 21, 2009 at 6:53 am
Gail has explained, at length, many of the behaviors of COUNT(*) over at her blog[/url]. In a nutshell, SQL Server is smart enough to figure out which index, table, statistic,...
"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
July 21, 2009 at 6:47 am
Main stream support for 2000 ends in June of next year, 2010. Which, is less than a year away... Yikes!
"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
July 21, 2009 at 6:41 am
Viewing 15 posts - 16,951 through 16,965 (of 22,226 total)