Viewing 15 posts - 17,656 through 17,670 (of 22,226 total)
I just did some tests on my own. I'm getting the same results you are. I never really tried this before, breaking a view down in this way. I'm seeing...
"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
April 21, 2009 at 12:20 pm
For the basics on identifying what's happening on a server, I'd recommend this white paper from Microsoft. It's a great read.
"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
April 21, 2009 at 12:08 pm
You will receive notification. I'm not sure if you can see that it was accepted on your profile or not. If I remember correctly from last year (and since remembering...
"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
April 21, 2009 at 11:37 am
The data would be something like
Name, Type
Joe Plumber
Tim Project Manager
Tom Developer
Etc.
Instead of what you're trying which is:
PlumberName, Project Manager...
"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
April 21, 2009 at 11:34 am
Sorry about that. The forum drove the answer. Steve's right. Profiler is your best, really your only, option.
"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
April 21, 2009 at 11:32 am
OK. Well you have two choices. Stop reloading it every week and use some unique identifiers for the transfer process, or build the unique identifiers off of natural keys. 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
April 21, 2009 at 9:25 am
If you're trying to determine if there are slow running queries, you'd be better off running queries against sys.dm_exec_query_stats. That will show you aggregate information about queries that are currently...
"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
April 21, 2009 at 9:14 am
Oh yeah. A few details may change, but the basic approach & scope is the same for 2008.
"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
April 21, 2009 at 9:00 am
Try this one
http://www.red-gate.com/specials/Grant.htm
I'm not sure it's still valid. Maybe the real book & Kindle are all that's available 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
April 21, 2009 at 8:58 am
It sure sounds like blocking, but since you say it's not, I'd step back a bit, not look at that procedure directly and instead examine the waits and queues on...
"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
April 21, 2009 at 8:48 am
GilaMonster (4/21/2009)
mithun.gite (4/21/2009)
GilaMonster (4/21/2009)
mithun.gite (4/21/2009)
Can any one give me a link for Query Optimization, using that i can start optimizing my queries?
I can suggest some books.
Inside SQL Server 2005: Query...
"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
April 21, 2009 at 8:45 am
I would have to see the code to fully understand the issue. However, no, there's no way to selectively limit the query defined within a view. The query is going...
"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
April 21, 2009 at 8:41 am
That's tough.
Without rearchitecting... I'd suggest setting up server side traces and capture query performance behavior. Then, go after the top poor performers. I'd focus on establishing a good set of...
"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
April 21, 2009 at 8:32 am
You basically need a baseline to compare against. I'd suggest collecting the information when there are very few users on the system and then when there are lots of users....
"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
April 21, 2009 at 8:29 am
The one thing no one seems to have mentioned is the selectivity of the data. Just because there are 10 columns and just because each of the 10 is used...
"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
April 21, 2009 at 8:18 am
Viewing 15 posts - 17,656 through 17,670 (of 22,226 total)