Viewing 15 posts - 15,901 through 15,915 (of 22,226 total)
I agree. If you're just moving the box, there's little you need to sweat on the server. But, you will need to validate that the clients aren't using IP &...
"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
January 27, 2010 at 7:34 am
GilaMonster (1/26/2010)
Grant Fritchey (1/26/2010)
Only the unique constraint on the index would be of use when looking at the execution plan.And whether or not it's filtered
Oh, true, didn't think about...
"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
January 26, 2010 at 8:02 am
There isn't one hard & fast number for most of these values. Almost all of them are dependent on your particular hardware and it's configuration. But, most performance monitoring or...
"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
January 26, 2010 at 7:51 am
One thing you can use to look at "hung" processes is to go after the dynamic management view sys.dm_exec_requests. This will show you the active processes in the server including...
"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
January 26, 2010 at 7:48 am
WayneS (1/25/2010)
GSquared (1/25/2010)
Grant Fritchey (1/25/2010)
"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
January 26, 2010 at 6:07 am
That's good. Buck Woody also did a fantastic presentation about it at the last PASS Summit.
"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
January 26, 2010 at 6:01 am
They can be any number of things. Lots of resources use tempdb within SQL Server, sort operations, table spools, hash joins, cursors, lots of stuff. You'll see that encrypted name,...
"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
January 25, 2010 at 7:48 am
Phil Factor (1/25/2010)
"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
January 25, 2010 at 7:29 am
I would strongly suggest you take a look at the Enterprise Policy Management Framework. It's from a Microsoft developer and it's free. It extends PBM for use with 2000 and...
"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
January 25, 2010 at 7:13 am
GilaMonster (1/25/2010)
Gianluca Sartori (1/25/2010)
Did you use your crystal ball, Gail? 🙂Sorry for the broken link, I'll fix it.
Didn't need to (and I think Grant has the crystal ball this week)....
"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
January 25, 2010 at 7:04 am
I think a lot of this, for me anyway, is just habit. Is there a good reason any more to put idx or ix at the beginning of index names?...
"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
January 25, 2010 at 6:31 am
I think you could store this in tables, but I'm not sure that you should resolve these in TSQL. However, if you did, then probably you'll need to apply a...
"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
January 22, 2010 at 7:01 am
homebrew01 (1/21/2010)
Grant Fritchey (1/21/2010)
homebrew01 (1/21/2010)
Grant Fritchey (1/21/2010)
homebrew01 (1/12/2010)
Near Danbury ConnecticutSo you're going to drive up for the next SNESSUG[/url] meeting, right?
I just looked it up ... Not exactly "down 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
January 21, 2010 at 10:56 am
homebrew01 (1/21/2010)
Grant Fritchey (1/21/2010)
homebrew01 (1/12/2010)
Near Danbury ConnecticutSo you're going to drive up for the next SNESSUG[/url] meeting, right?
I just looked it up ... Not exactly "down the street" from me.
Oh,...
"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
January 21, 2010 at 10:16 am
Unfortunately no. That's just too vague a question to be able to answer it with any meaning or depth.
The first question I'd ask, when you say that you're storing business...
"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
January 21, 2010 at 7:53 am
Viewing 15 posts - 15,901 through 15,915 (of 22,226 total)