Viewing 15 posts - 11,926 through 11,940 (of 22,224 total)
Just understand, it's a common misconception, but putting in READ UNCOMITTED or NOLOCK is not a "run faster" switch for SQL Server. It can increase some performance in some areas,...
"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
September 2, 2011 at 8:58 am
GilaMonster (9/2/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
September 2, 2011 at 8:46 am
Page life expectancy shows how long pages have been in memory. That's it. A long time is good. The longer the better. I've seen weeks without a page flush before....
"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
September 2, 2011 at 8:13 am
It's going to be nothing but GUIDs pointing out to some file location somewhere.
"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
September 2, 2011 at 5:23 am
jared-709193 (8/31/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
August 31, 2011 at 10:25 am
You can look at queries in the cache to see if the database has been accessed recently: sys.dm_exec_query_stats. But that's only as good as the queries in cache. If 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
August 31, 2011 at 7:53 am
If you have a slow query that you've already identified as the point of pain, take a look at the execution plan for that query. That's going to tell 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
August 31, 2011 at 7:51 am
First, why insert twice? That's two times the labor and work for SQL Server.
Second, have you looked at the execution plans? That will tell you how things are behaving 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
August 31, 2011 at 7:39 am
You mean a user defined function in TSQL? That's just another way of writing a query (assuming we're not talking table valued user defined functions). There isn't, per se, 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
August 31, 2011 at 7:35 am
What are the statements after that in the transaction?
"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
August 31, 2011 at 7:33 am
To my knowledge, this needs to be part of the backup command. I don't think there's a way to set a default value for all backups. I'm doing some checking...
"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
August 31, 2011 at 7:24 am
That's a huge question and it begs clarification. At a very high level SQL Server architecture can refer to knowing the differences between the relational storage engine, reporting services, integration...
"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
August 31, 2011 at 7:20 am
mtillman-921105 (8/29/2011)
GSquared (8/29/2011)
Marx/Engels called for the successful to be slaughtered by the unsuccessful in the establishment of "The Tyranny of the Proletariat" (Socialism) as a step on the way to...
"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
August 29, 2011 at 4:14 pm
GilaMonster (8/29/2011)
And right on cue, a PM that's leaning towards harassment. <sigh>Why do some people think that just because I've answered a couple of their questions that I'm their BFF?
But......
"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
August 29, 2011 at 4:11 pm
Data collection could affect performance. I've never seen it do that much to a system before though. Did you look at blocking processes or do you have a metrics 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
August 27, 2011 at 4:52 am
Viewing 15 posts - 11,926 through 11,940 (of 22,224 total)