Viewing 15 posts - 19,906 through 19,920 (of 22,219 total)
There is a way to do this, but you need to be very careful about how you use it. I'd suggest, if possible, only running it against a test system...
"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 23, 2008 at 9:06 am
It's not really possible to suggest solutions without understanding the problem. You have a query that is running too long. OK. You've got the basic information of duration, CPU 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
July 23, 2008 at 6:25 am
There's no way to pass a where clause and get an estimated row count that I'm aware of.
That said, if you get an estimated execution plan, you'll get an...
"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 23, 2008 at 6:20 am
Can you show the column names too? We need to understand where Tidspunkt is coming from.
"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 23, 2008 at 6:17 am
Just a guess, you're running against a SQL Server 2000 instance. This is the 2005 forum and the solution offered was one that works there.
"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 23, 2008 at 6:14 am
If I understand the question, you mean that you have a proc, Y. Within that proc it makes a call to another proc X. Within the proc X you're attempting...
"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 23, 2008 at 6:13 am
Nice article, Tom. Thanks for sharing that solution. I'm passing it on to our OpsMgr admin to see if he can use it.
"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 23, 2008 at 5:55 am
Just the System Monitor counters is all I've ever had available. I use Operations Manager to collect those now, but you could just use Performance Monitor.
"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 23, 2008 at 5:24 am
SSIS does do a great job. You can also run the script manually and output the results to a file through Management Studio. You can also use sqlcmd.exe to run...
"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, 2008 at 12:02 pm
But that assumes you're not worrying about extended character sets. Wouldn't that muck with international 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
July 22, 2008 at 11:53 am
CHAR or VARCHAR is one half the size of NCHAR or NVARCHAR.
The N designates the data type as unicode which stores at twice as much data for each character.
"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, 2008 at 11:53 am
Use good indexes, especially the clustered index. Look into partitioned tables where appropriate. Use partitioned views where appropriate. Only denormalize where you can guarantee a tested performance benefit. Test everything...
"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, 2008 at 8:43 am
OK. Well, that was useless.
Hmmm... If we were comparing reads of 10000 rows of VARCHAR to NVARCHAR, I wouldn't be surprised by a two-fold increase in speed. I'm a little...
"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, 2008 at 8:37 am
Oh, I've got one of those for the dog... it'll 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
July 22, 2008 at 6:24 am
I'd be more interesting in seeing the execution plan from the 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
July 22, 2008 at 6:23 am
Viewing 15 posts - 19,906 through 19,920 (of 22,219 total)