Viewing 15 posts - 13,351 through 13,365 (of 22,224 total)
Tom.Thomson (2/8/2011)
Craig Farrell (2/8/2011)
*sighs* I've failed sainthood. I leave this gentleman in your hands, he can't even debate well, and my patience is stretching to the unprofessional realms.http://www.sqlservercentral.com/Forums/Topic1059167-145-1.aspx
I've joined...
"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
February 9, 2011 at 4:37 am
sqldba_icon (2/8/2011)
Grant Fritchey (2/8/2011)
sqldba_icon (2/8/2011)
i) In my proc i have the following options set up
Set ANSI_NULLS ON
go
SET QUOTED_IDENTIFIERS ON
go
Set Transaction isolation level read uncommitted
SET NOCOUNT...
"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
February 9, 2011 at 4:30 am
sqldba_icon (2/8/2011)
i) In my proc i have the following options set up
Set ANSI_NULLS ON
go
SET QUOTED_IDENTIFIERS ON
go
Set Transaction isolation level read uncommitted
SET NOCOUNT ON
ii) This article...
"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
February 8, 2011 at 3:58 pm
Gianluca Sartori (2/8/2011)
Grant Fritchey (2/8/2011)
Hey, while I've got you guys here, when I was off the network, the Virtual Box and the laptop stopped communicating. I'm sure I've got 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
February 8, 2011 at 3:41 pm
Assuming you're getting an actual execution plan from the trace or through management studio, they're the same because they're coming from identical sources. Neither does anything that the other does...
"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
February 8, 2011 at 2:44 pm
pavan_srirangam (2/8/2011)
I think the code nam edenali is sql server 2011 I guess not sql 2010.
If it comes out on schedule, it will be SQL 2011, yes.
"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
February 8, 2011 at 12:39 pm
parissa_bakhshi (2/8/2011)
and also memory , but SQL always takes the memory till a process need it. goof buffer cache hit...
"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
February 8, 2011 at 12:36 pm
Bungholio (2/8/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
February 8, 2011 at 12:22 pm
ericwenger1 (2/8/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
February 8, 2011 at 11:58 am
Check this article from SQL Server Magazine. It shows how you can query msdb tables to see backup information. It won't tell you how the call was made, but 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
February 8, 2011 at 9:26 am
parissa_bakhshi (2/8/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
February 8, 2011 at 9:10 am
It could be resource contention. I'd check the wait states to see what's causing things to slow down. Also you can monitor calls as they're running slow using sys.dm_exec_requests 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
February 8, 2011 at 9:00 am
SKYBVI (2/8/2011)
I am the only guy who does the backup so im pretty sure that the backups are...
"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
February 8, 2011 at 8:59 am
Tom Brown (2/8/2011)
Just wondered why, no one mentioned VmWare or Hyper-V?
As far as I know Hyper-V is only available on Windows 2008 Server...
"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
February 8, 2011 at 8:56 am
No, I think you might be in a minority there. Where I was working was using PBM to monitor backup age, agent status, and a bunch of other server settings...
"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
February 8, 2011 at 8:38 am
Viewing 15 posts - 13,351 through 13,365 (of 22,224 total)