Viewing 15 posts - 41,011 through 41,025 (of 49,552 total)
<Sigh> Why don't people read the manuals?
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
February 17, 2009 at 1:54 pm
murthykalyani (2/17/2009)
Once this is done, you can truncate your log.
Um, if this database is in full recovery and log backups are been done, then a log backup can be done,...
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
February 17, 2009 at 1:53 pm
Look up "ALTER AUTHORIZATION" in Books Online. There is both a detailed explanation and a number of examples
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
February 17, 2009 at 1:51 pm
Why do you want to do that?
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
February 17, 2009 at 1:13 pm
cafescott (2/17/2009)
I'm still playing with these settings, trying to avoid the error. thanks.
The error's saying that it's taking too long to grow the file by the required 20 MB....
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
February 17, 2009 at 1:09 pm
cafescott (2/17/2009)
I click the Autogrowth button...
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
February 17, 2009 at 1:07 pm
Well, why do you need to fail back? What's wrong with just leaving the former mirror as the principal?
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
February 17, 2009 at 1:02 pm
Sailor (2/17/2009)
Perhaps as a preventative measure, how often should I run check db?
There's no right answer for that. Run it often enough that if is does find corruption you can...
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
February 17, 2009 at 12:56 pm
louisevb (2/17/2009)
Oops it is Gail, sorry i am half asleep morning 😀
😀
Either works, I don't mind.
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
February 17, 2009 at 1:21 am
By updating stats after rebuilding indexes, you've left the statistics less accurate than they would have been. Index rebuild updates all stats with fullscan. If you then do a sampled...
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
February 17, 2009 at 12:37 am
You've got transactional replication set up and a log reader that's never run. Is that database supposed to be replicated?
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
February 17, 2009 at 12:29 am
sunny1_liu (2/16/2009)
But in my opinion, profiler may consume many system resources, so we hardly turn it on unless really necessary.
So don't use profile. You shouldn't be using profiler on a...
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
February 17, 2009 at 12:28 am
Looks like a IO failure. Any drive problems?
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
February 17, 2009 at 12:25 am
bodhilove (2/16/2009)
Hi when I run a dbcc it seems to take up all my buffer cache.
Hardly surprising. CheckDB is very intensive and it has to read the entire database,...
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
February 17, 2009 at 12:24 am
Enable traceflag 1222. It will write the deadlock graph into the error log whenever a deadlock occurs. Please post the deadlock graph here and we'll try and help.
A single query...
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
February 17, 2009 at 12:21 am
Viewing 15 posts - 41,011 through 41,025 (of 49,552 total)