Viewing 15 posts - 15,196 through 15,210 (of 49,552 total)
The optimise for ad-hoc workloads option does not exist in SQL 2005. It was added in SQL 2008.
p.s. you may want to change 'allow updates' back to 0 if you...
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
December 18, 2012 at 2:05 am
Don't use Task Manager to check SQL's memory. It can be completely wrong.
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
December 18, 2012 at 2:03 am
If the restore completed but was run WITH NORECOVERY then run RESTORE DATABASE <db name> WITH RECOVERY
If you aborted the restore part way through, drop the DB and run the...
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
December 18, 2012 at 1:59 am
I would advise that you don't. There's nothing that suggests in any way that there's any corruption or damage to the DB, and if there was, repair software would 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
December 18, 2012 at 1:53 am
SQL cannot compare two different data types, nor can it multiply by a string. Hence, any time you ask it to do that, it will do an implicit conversion. As...
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
December 17, 2012 at 4:39 pm
Autogrow is not logged to the error log unless it times out, takes excessively long or fails. Try the default trace.
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
December 17, 2012 at 3:42 pm
Craigmeister (12/17/2012)
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
December 17, 2012 at 3:24 pm
Craigmeister (12/17/2012)
The issue is from the trigger causing lock escalation,
No, the trigger is not causing lock escalation. Lock escalation is to table always, we're dealing with page and row locks...
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
December 17, 2012 at 1:15 pm
All right, so if we discard all the parallelism mess (which is mostly irrelevant noise), we have this:
spid=52, running a statement within a trigger
UPDATE BART_V3_TBL_ORDERS SET BART_V3_TBL_ORDERS.DateLastChanged = GETDATE()
FROM BART_V3_TBL_ORDERS
INNER...
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
December 17, 2012 at 12:30 pm
Performance Monitor. Total Server memory counter (it's a SQL counter)
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
December 17, 2012 at 11:26 am
Don't use Task Manager to check SQL's memory usage. It doesn't report correctly.
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
December 17, 2012 at 11:23 am
Profiler.
And index hints should be your last resort, not your first idea.
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
December 17, 2012 at 9:54 am
Can you post the entire deadlock graph please? By the looks of it, you've simplified out info that I need to see what's happening.
Can you also post the table definition...
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
December 17, 2012 at 8:03 am
Restoring or recovering?
Restoring means that the DB is in the process of being restored from a backup. Check the error log, see what happened.
Try RESTORE DATABASE <database name> WITH RECOVERY,...
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
December 17, 2012 at 7:59 am
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.
DBCC TRACEON(1222,-1)
How...
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
December 17, 2012 at 2:46 am
Viewing 15 posts - 15,196 through 15,210 (of 49,552 total)