Viewing 15 posts - 38,326 through 38,340 (of 49,552 total)
John Doe (6/18/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
June 18, 2009 at 10:45 am
jvs (6/18/2009)
This is the third time it did it. Orginally the database worked fine for 2 days and then corrupted.
I would take a long, hard look at that 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
June 18, 2009 at 10:30 am
Steve Jones - Editor (6/18/2009)
Both require hard work, but the MCA requires some serious hard $$$ as well.
And a hell of a lot of time in Redmond.
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 18, 2009 at 10:27 am
Your database files are in a compressed folder/drive. Uncompress the folder and it should be fine.
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 18, 2009 at 10:25 am
Please post index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
You can also have a look at this blog post on the performance implications of scalar UDFs http://sqlinthewild.co.za/index.php/2009/04/29/functions-io-statistics-and-the-execution-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
June 18, 2009 at 10:04 am
Both temp tables and table variables are created in TempDB.
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 18, 2009 at 9:51 am
Please can you run the following and post the full results
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
I would guess that it's a hardware issue, specifically the IO...
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 18, 2009 at 9:51 am
I did public speaking for 3 years at high school. Was ok, I didn't enjoy it that much. Apparently some of the things they taught sank in.
What I've found, by...
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 18, 2009 at 9:49 am
Thanks. I need to play with both, but since I don't have an actual prod server to play with, it's going to have to be in a lab based 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
June 18, 2009 at 9:45 am
Are you sure that the server's SQL 2005 or 2008? The save-as will be greyed out if the server is SQL 2000. If that's the case, follow the steps 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
June 18, 2009 at 9:41 am
ankur_libra (6/18/2009)
Is there any way to delete an individual entry from the error log file as well?
Short of cycling the log, opening the old log file in a text editor,...
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 18, 2009 at 9:23 am
Alvin Ramard (6/18/2009)
GilaMonster (6/18/2009)
Dugi (6/18/2009)
Ha, seems you are more stupid than Q, so it is hard for you to understand!Insulting him is uncalled for.
That ok. I'm not going to...
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 18, 2009 at 8:44 am
What's weird about those results?
Check how long those log readers have been running. It usually continuous since the last time the server was started, which could account for the high...
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 18, 2009 at 8:42 am
Can you run a checkDB on that database please. Sometimes that message is because of corruption.
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
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 18, 2009 at 8:35 am
You can use RAISERROR ... WITH LOG if you're a sysadmin user or have ALTER TRACE permissions
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 18, 2009 at 8:35 am
Viewing 15 posts - 38,326 through 38,340 (of 49,552 total)