Viewing 15 posts - 42,616 through 42,630 (of 49,552 total)
ScottPletcher (12/3/2008)
I prefer to say that the log should not be truncated at all.
That's not practical in this type of situation.
If the log is already bloated because it previously wasn't...
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 3, 2008 at 1:46 pm
Are the two files that SQL's looking for there?
And the error log after SQL restarted?
Are there any IO-related errors in the windows event 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
December 3, 2008 at 9:35 am
Can you check the versions that I asked about above?
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 3, 2008 at 9:26 am
And the error log from after the restart? When the DB went into recovery?
Does the G drive still exist? Can you see it, can you read files on it?
SQL's looking...
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 3, 2008 at 9:24 am
Do you have showplan_all or showplan_text on?
That option means the query won't get executed, just parsed and optimised. The query's not actually running, so there's no stats output.
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 3, 2008 at 9:08 am
Mike Levan (12/3/2008)
I am not sure all of a sudden y this error occured.
You've got disk problems.
I can not see the error log as i just restarted.
It's a text file...
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 3, 2008 at 9:07 am
Can you please post the contents of your error log? (it's a file just called errorlog, text file)
An 823 error is a hard IO error. It means SQL requested an...
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 3, 2008 at 8:58 am
Can you do a maint plan to backup to disk (not to a backup device)?
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 3, 2008 at 8:52 am
Did you turn statistics io on?
Are there rows in both of those tables?
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 3, 2008 at 8:26 am
Please run SELECT @@version on the server and post the results. Please go to the help menu in management studio, select About Management studio and copy the version listed there...
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 3, 2008 at 8:23 am
umanpowered (12/3/2008)
If I'm understanding SQL 2005 DBMS correctly, the DBMS "engine" has some impact on the the underlying system tables. Maybe I'm way off base here, so I apologize...
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 3, 2008 at 8:19 am
It's an ebook and Simple Talk was distributing it. Drop a PM/mail to Tony Davis (here or over at simple talk) and ask.
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 3, 2008 at 7:56 am
What's a form id?
Your questions aren't making much sense by themselves. Can you please explain, in detail, what you're trying to do and what's not working?
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 3, 2008 at 7:37 am
Jack Corbett (12/3/2008)
Use Gail's solution. Mine didn't handle values with .00 correctly.
Mine had that problem too, before I remembered about Ceiling.
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 3, 2008 at 7:35 am
smunson (12/3/2008)
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 3, 2008 at 7:24 am
Viewing 15 posts - 42,616 through 42,630 (of 49,552 total)