Viewing 15 posts - 44,131 through 44,145 (of 49,552 total)
Jeff Moden (9/30/2008)
Gail is correct, but just curious... you need more than 249 indexes on a single table? 😛
It's actually not hard to hit on larger tables, seeing as automatically...
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
September 30, 2008 at 6:58 am
Vinesh (9/30/2008)
gail,fix replication first
What do you mean by this?
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
September 30, 2008 at 6:42 am
Not one of that size. I believe the usual recommendation for user databases is a number of files = no more than 1/4-1/2 number of cpus. You definitely don't want...
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
September 30, 2008 at 4:29 am
george sibbald (9/29/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
September 30, 2008 at 3:57 am
To add to that, make sure that you have check constraints and unique constraints where applicable and that you are using appropriate data types.
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
September 30, 2008 at 3:28 am
Ouch. Your IO performance looks terrible. Average of 44 sec for an async IO completion with a max of 22 minutes is way, way too high.
I can't download the perfmon...
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
September 30, 2008 at 3:06 am
PaulB (9/30/2008)
Not sure how critical is the issue for you but better to get the Oracle Service Request upgraded to either sev=1 or sev=2 - in my...
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
September 30, 2008 at 2:54 am
That alone won't cause the log to be full, which it appears to be.
The solution is to sort out the replication and find out why you have so many undistributed...
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
September 30, 2008 at 2:52 am
I can't help you with the primary key. The column must be unique and not null. From what you've posted, there's not enough info to ID the primary key.
Post 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
September 30, 2008 at 2:49 am
Suspended indicates they're waiting for a resource. What are they waiting for? If they're blocked, by what process and what is that doing?
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
September 30, 2008 at 2:47 am
jvElecenter (9/29/2008)
se this database is published. When i disable I can shrink it without any problem. But whem I drop the publication I'm losing all my replications.
Your log reader is...
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
September 29, 2008 at 2:25 pm
homebrew01 (9/29/2008)
Replication shouldn't make any difference. When was your last FULL backup ?
Replication makes a big difference to logs. On a replicated DB, the log record can't be discarded until...
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
September 29, 2008 at 2:22 pm
Looks like there's a damaged page in the backup. Can you get another copy of the backup?
If not, try a restore with continue after error in 2005 or 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
September 29, 2008 at 2:20 pm
Fraggle (9/29/2008)
Did you try using the CAST function?
It may convert, but the conversion will be completely meaningless. timestamp is not in anyway related to a time.
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
September 29, 2008 at 2:17 pm
ALZDBA (9/29/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
September 29, 2008 at 2:16 pm
Viewing 15 posts - 44,131 through 44,145 (of 49,552 total)