Viewing 15 posts - 11,866 through 11,880 (of 22,219 total)
Chad Crawford (9/12/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 12, 2011 at 1:57 pm
The performance counters would be primarily waits and queues, but you need to combine perfmon with query behavior. You can't just measure one or just the other. What's the page...
"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 12, 2011 at 9:35 am
Since this is a reporting system, you might not want to go as high with the cost threshold, 25-30, which means your average cost of 35 might still get parallelism.
CXPacket...
"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 12, 2011 at 8:26 am
Ninja's_RGR'us (9/12/2011)
Imagine losing 1 out of 100 dbs. It's annoying to very problematic, but if ALL of them go...
"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 12, 2011 at 5:59 am
nikk_Stone (9/10/2011)
thnx...but the book which you have told me...it is not free of cost...
i have to buy it online...
i want a frre book
There are some free books out there. 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
September 12, 2011 at 5:47 am
Yes and yes. If the system databases go offline, you're just as in trouble as if the user database went offline.
"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 12, 2011 at 5:35 am
I know, I know, I know what you're going to say, but I can't help thinking that this could be a handy graphic to keep around:
Besides, I like cats. 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
September 9, 2011 at 3:42 pm
syen (9/9/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 9, 2011 at 9:04 am
syen (9/9/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 9, 2011 at 7:58 am
Ben Moorhouse (9/9/2011)
Grant Fritchey (9/9/2011)
I consider military service a plus, but degree's... nope.I hadn't even considered that!
Is there a specific skill/discipline you like to glean from military service?
Not really. Just...
"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 9, 2011 at 6:17 am
SwayneBell (9/9/2011)
Grant Fritchey (9/8/2011)
GilaMonster (9/8/2011)
SwayneBell (9/8/2011)
GilaMonster (9/8/2011)
All the sessions were recorded, they'll be up on the PASS website in a few weeks.
That's great news Gail!
I'm sure that you'll lose...
"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 9, 2011 at 6:06 am
I came into this career without a CS degree. Still don't have one. What I do have is 20 years of experience (and that mostly is 20 years of experience,...
"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 9, 2011 at 6:01 am
Ninja's_RGR'us (9/8/2011)
Grant Fritchey (9/8/2011)
GilaMonster (9/8/2011)
SwayneBell (9/8/2011)
GilaMonster (9/8/2011)
All the sessions were recorded, they'll be up on the PASS website in a few weeks.
That's great news Gail!
I'm sure that you'll lose...
"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 8, 2011 at 3:32 pm
GilaMonster (9/8/2011)
SwayneBell (9/8/2011)
GilaMonster (9/8/2011)
All the sessions were recorded, they'll be up on the PASS website in a few weeks.
That's great news Gail!
I'm sure that you'll lose me five seconds...
"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 8, 2011 at 12:55 pm
Ninja's_RGR'us (9/8/2011)
I'm a moron, don't listen to me. Anything I say can destroy your servers and have you fired for doing what 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
September 8, 2011 at 10:37 am
Viewing 15 posts - 11,866 through 11,880 (of 22,219 total)