Viewing 15 posts - 36,181 through 36,195 (of 49,552 total)
Also, http://sqlinthewild.co.za/index.php/2007/11/15/execution-plan-operations-scans-and-seeks/
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
October 23, 2009 at 3:27 am
The error says to query sys.databases to see why the log cannot be reused.Have you done so? If so, what is the value of log_reuse_wait_desc for the DB in question?
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
October 23, 2009 at 3:26 am
Jeff Moden (10/22/2009)
The only thing that remains if for you guys to tell us a fool proof way to find a good local tuner. 😉
Ask for references, contact those references...
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
October 23, 2009 at 3:12 am
It's for a batch of statements. It's the graphical plan (a .sqlplan file) and I can't get the text plan.
So open in xml editor and 'edit' into several plan files?
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
October 23, 2009 at 3:06 am
Krasavita (10/22/2009)
What do you mean and take a full backup to restart the log chain?
If you were going to switch it back to full recovery, you would need to 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
October 22, 2009 at 9:49 am
Once the san repairs are 'finished', check the windows event log, make sure there are no IO-related errors. Make sure you know where your backups are, in case you need...
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
October 22, 2009 at 9:47 am
Animal Magic (10/22/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
October 22, 2009 at 9:27 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic806976-149-1.aspx
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
October 22, 2009 at 3:07 am
su_kumar11 (10/22/2009)
and if my database has been crashed at 12.30 pm .Then how i will recover...
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
October 22, 2009 at 2:51 am
agriggs 11853 (10/21/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
October 21, 2009 at 2:32 pm
Take a look at this blog post and the two that follow it.
http://www.brentozar.com/archive/2009/04/how-to-get-a-junior-dba-job-part-1/
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
October 21, 2009 at 2:21 pm
UncleBoris (10/21/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
October 21, 2009 at 2:16 pm
agriggs 11853 (10/21/2009)
running a task every 30 minutes to shrink the log files, with truncate.
Bad idea. Exceedingly bad idea. Please go to the person who told you to do...
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
October 21, 2009 at 2:14 pm
HowardW (10/21/2009)
It was my understanding that regardless of recovery interval, the data files are not written to until the transaction is committed?
Nope. When checkpoint runs it writes ALL dirty pages...
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
October 21, 2009 at 10:02 am
Timothy Patihk (10/21/2009)
Yes, we are thinking of network problems, and are exploring ways to prove this
The proof is in the error message - "The specified network name is no longer...
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
October 21, 2009 at 9:46 am
Viewing 15 posts - 36,181 through 36,195 (of 49,552 total)