Viewing 15 posts - 32,326 through 32,340 (of 49,552 total)
Please post table definitions, index definitions and execution plan (if possible) as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
June 21, 2010 at 8:41 am
Oracle_91 (6/21/2010)
Max is set to 12 GB i.e total available memory.
Now my doubt is whether is...
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
June 21, 2010 at 8:37 am
What's in the error log is just the short stack dump. Got the .mdmp file? That's the full stack dump that you would open in a debugger (assuming that 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
June 21, 2010 at 8:32 am
Contact Microsoft's customer support people. They have tools to interogate stack dumps.
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
June 21, 2010 at 8:07 am
If the log starts filling up again, run DBCC OPENTRAN and post the results.
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
June 21, 2010 at 7:10 am
To be safe, any check for unused objects should cover an entire business cycle. If you have reports/queries/jobs that run only on month ends, the check much cover a month...
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
June 21, 2010 at 7:03 am
What about staging type tables that are populated, used then wiped?
p.s. that's 0 record modifications since the last stats update/index rebuild.
p.p.s. Why join in sys.indexes?
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
June 21, 2010 at 6:40 am
Could anything be setting the DB back to full recovery? Altering the DB to Simple when its already in simple should do nothing.
Is there replication configured? Does opentran say anything...
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
June 21, 2010 at 6:34 am
Please no! I have those things going crazy outside my flat until around midnight every night already.
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
June 21, 2010 at 5:38 am
Size of the buffer is not relevant here. Log records MUST be written to disk when a transaction commits, regardless of how full or not the log buffer is.
What kind...
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
June 21, 2010 at 5:37 am
http://www.google.com/search?q=inner+Join+site%3Amsdn.microsoft.com
http://www.google.com/search?q=Left+Outer+Join+site%3Amsdn.microsoft.com
http://www.google.com/search?q=Right+Outer+Join+site%3Amsdn.microsoft.com
http://www.google.com/search?q=cross+Join+site%3Amsdn.microsoft.com
http://www.google.com/search?q=self+Join+site%3Amsdn.microsoft.com
http://www.google.com/search?q=merge+Join+site%3Amsdn.microsoft.com
http://www.google.com/search?q=hash+Join+site%3Amsdn.microsoft.com
http://www.google.com/search?q=loop+Join+site%3Amsdn.microsoft.com
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
June 21, 2010 at 5:11 am
Have you tried google?
http://sqlinthewild.co.za/index.php/2007/12/30/execution-plan-operations-joins/
http://sqlinthewild.co.za/index.php/2009/11/24/the-most-optimal-join-type/
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
June 21, 2010 at 4:52 am
ahmed_sag4f5 (6/21/2010)
How much time it will take to scam the table..it is still very slow....
Depends on the size of the table. One a large table it will be slow. Take...
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
June 21, 2010 at 4:45 am
Why? What are you investigating?
The log buffer is pretty small, it's where log records are written before they're hardened to disk
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
June 21, 2010 at 4:41 am
Log cache?
I know of a data cache and a log buffer.
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
June 21, 2010 at 3:19 am
Viewing 15 posts - 32,326 through 32,340 (of 49,552 total)