Viewing 15 posts - 33,826 through 33,840 (of 49,552 total)
That's normal, the checkpoint and the backup log both have to write to the transaction log, hence one will block the other.
If it's happening often, check the duration of checkpoint,...
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 25, 2010 at 12:20 am
Please post new questions in a new thread. Thank 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
February 24, 2010 at 12:50 pm
AndrewSQLDBA (2/24/2010)
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 24, 2010 at 12:48 pm
A page restore will not work here. Besides, it looks like there's more than just three pages damaged. The comment about not being able to latch a page with reason...
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 24, 2010 at 11:54 am
Too high? That's a value of 0.0000035. Why do you think that's too high and why do you think that the index isn't useful?
Density is defined as 1/(number of unique...
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 24, 2010 at 11:31 am
If you want some reading on corruption, you could start with this. http://www.sqlservercentral.com/articles/Corruption/65804/
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 24, 2010 at 11:27 am
Fatal.
You have damage to a couple of your allocation pages (specifically PFS pages). This kind of corruption is irreparable.
Take a tail-log backup (if you can), then restore your full...
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 24, 2010 at 11:25 am
Lynn Pettis (2/24/2010)
Please be aware that by using the ALLOW_DATA_LOSS repair option you may have done just that, lost data.
However it is the only repair level allowed when the...
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 24, 2010 at 11:08 am
Joy Smith San (2/24/2010)
Sometimes application runs very very slow.
That isn't necessarily insufficient memory. Yes, memory may help, but you should also look at what's running and see what needs fixing/changing...
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 24, 2010 at 3:07 am
Enable traceflag 1222. That will write a deadlock graph into the error log whenever a deadlock occurs. Post it here.
Most deadlocks are a result of non-optimal code or non-optimal 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
February 24, 2010 at 1:23 am
12-14 GB. No more (and I'd err on the lower end of that). OS needs memory to manage memory, not good to starve it.
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 24, 2010 at 1:22 am
david.c.holley (2/23/2010)
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 24, 2010 at 12:13 am
GT-897544 (2/23/2010)
Incase if you need old database take a snapshot of database before restore, so that if you think you need revert back just revert back snapshot.
Are you talking about...
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 24, 2010 at 12:06 am
Find out why it's down. All other troubleshooting steps will be based on the results of 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 23, 2010 at 11:57 pm
GT-897544 (2/23/2010)
What is the status column value when you query select * from sysdatabases.
since this is in the 2005 forums (and hence should be a 2005 database) SELECt state_desc from...
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 23, 2010 at 11:52 pm
Viewing 15 posts - 33,826 through 33,840 (of 49,552 total)