Viewing 15 posts - 26,296 through 26,310 (of 49,552 total)
Please read through this - Managing Transaction Logs[/url]
and maybe this http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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
May 6, 2011 at 5:01 am
What do you mean by a recovery point?
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
May 6, 2011 at 5:00 am
chandan_jha18 (5/6/2011)
In the table variable @T the row count is 4834
That's well over what I'd put into a table variable due to the lack of statistics and its effect on...
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
May 6, 2011 at 4:59 am
GilaMonster (5/5/2011)
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/Did you check for blocking?
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
May 6, 2011 at 4:58 am
How many rows in the table variable?
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
May 6, 2011 at 2:20 am
How have you tested?
The first insert into a temp table will always recompile. Subsequent ones should not.
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
May 6, 2011 at 2:07 am
It doesn't necessarily have to show up in activity monitor. If someone ran a large transaction, the query finished, but the commit never happened, that would require a rollback but...
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
May 6, 2011 at 2:05 am
Please don't post in all caps. It's the equivalent of shouting at us.
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Did you check for blocking?
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
May 5, 2011 at 1:34 pm
Long running transaction that it needs to roll back?
With Rollback Immediate it will start the roll back immediately. Has to finish it, if there's a long-running, large transaction that...
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
May 5, 2011 at 11:27 am
Shrink is never going to remove space that's unused in a table. It only works on unallocated data pages. It will be slow as hell if you have LOB data,...
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
May 5, 2011 at 9:46 am
What does that batch job do?
First thing we need to do before anything else is identify why it is suspect. Open up the SQL error log and look for all...
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
May 5, 2011 at 9:42 am
The only one I know is Apex SQLLog.
Why not triggers? Monitoring data changes is one of their main purposes. The transaction log is not intended as an audit log.
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
May 5, 2011 at 7:52 am
For what purpose?
Log readers aren't cheap. All the ones I've seen are around $1000 per licence.
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
May 5, 2011 at 7:29 am
How did you migrate the DB?
Are you sure no indexes were missed?
Memory setting correctly configured?
Not perhaps on an inferior IO subsystem?
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
May 5, 2011 at 7:24 am
Try Alter Index ... Reorganise with the lob compaction option.
You need to either rebuild or reorganise after that shrink anyway.
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
May 5, 2011 at 7:18 am
Viewing 15 posts - 26,296 through 26,310 (of 49,552 total)