Viewing 15 posts - 41,281 through 41,295 (of 49,552 total)
colin Leversuch-Roberts (2/1/2009)
OP ?
Original Poster
In theory doing a select * may seem a solution, however having observed memory usage from many angles, including having 64GB of ram for...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 1, 2009 at 11:36 pm
RBarryYoung (2/1/2009)
But Marios should be able to get the Actual from Profiler or tracing, right?
Yes, absolutely. Providing he traces the correct event. I seem to recall there are about 6...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 1, 2009 at 11:34 pm
Marios Philippopoulos (2/1/2009)
I don't think it's the estimated exec plan, I obtained it from sys.dm_db_exec_requests. It was retrieved when the statement was actually executed...
It's the same as the 'estimated' plan....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 1, 2009 at 2:06 pm
binettec (2/1/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 1, 2009 at 10:11 am
Jeff Moden (2/1/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 1, 2009 at 10:03 am
Check the SQL error log. There should be an entry that states why SQL is marking the databases suspet. If you'renot sure, post that and any other error messages relating...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 1, 2009 at 5:17 am
Can you perhaps post the trigger code?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 1, 2009 at 5:16 am
Perry Whittle (1/31/2009)
as Gail pointed out remember that to make the passive node active would require a new set of disk resources for the 2nd active instance.
And even if...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 1, 2009 at 5:14 am
Phillip Cox (2/1/2009)
shared scalable databases
Just for your info, scalable shared databases are not a new 2008 feature. 2005 had the capability. It wasn't well knows, I doubt it was used...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 1, 2009 at 5:00 am
This was removed by the editor as SPAM
January 31, 2009 at 10:34 am
Josh Turley (1/30/2009)
I'll just add a step to the scheduled job to truncate the log then.
Ur, why?
If you need point-in-time recovery, schedule log backups.
If you don't need point-in-time...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 31, 2009 at 10:18 am
myst.black (1/30/2009)
Is it possible to set up replication on the passive node instead? If so, what are the drawbacks?
Bear in mind that, with clustering there's only a single copy of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 31, 2009 at 10:12 am
Please read through the article that Terry posted, and also this one - Managing Transaction Logs[/url]
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 31, 2009 at 10:10 am
Probably something's missing in the error handling. Can you post the outer stored proc?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 31, 2009 at 10:10 am
sqlfriend (1/30/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 31, 2009 at 9:59 am
Viewing 15 posts - 41,281 through 41,295 (of 49,552 total)