Viewing 15 posts - 121 through 135 (of 137 total)
In in opinion and in my shop No.
Run this command and private message me the results or post for the tables:
DBCC SHOWCONTIG WITH ALL_INDEXES,FAST, TABLERESULTS
Depending on how big your database...
March 22, 2007 at 8:31 am
I think it is pretty clear that your indexes are the problem. Your waitstats is probably just reflecting that. I run the dbcc dbreindex and then take a fresh look...
March 21, 2007 at 7:50 pm
I agree with Steve but would recommand a showcontig on both servers so you can compare the indexes. That could help you narrow it to specific tables...
March 21, 2007 at 9:58 am
Couple of questions:
Is RAID level on the new server the same as the old?
How did you build the new database?
Are the doing the same thing and how is the traffic...
March 17, 2007 at 8:44 am
It looks like your server had a general access violation. You probably have one or more dump files in your log directory. If this happens a lot...
September 28, 2006 at 8:22 pm
If you use this widget from Gert D. you can script out all the jobs on a server. Using your perferred text editor you can do a global replace...
September 28, 2006 at 8:17 pm
The index and stats suggestions are all good ideas but you original post says the applicaitons are writing data. Removing data hasn't help much either so I'm guessing...
September 19, 2006 at 4:00 pm
If the server is running I would have doubts about a corrupt master. Does dbcc checkdb run clean?
If it passes dbcc checkdb, the data loss is probably human...
September 13, 2006 at 10:52 am
In your first post you say it resolves its self and runs for a week after a reboot. Can you explain this a little more and describe each step...
September 11, 2006 at 8:09 am
This might be obvious but I would double check the default database of your logins. It sounds like a database context problem somewhere.
September 7, 2006 at 8:43 pm
The fact that the problem goes away with a reboot and comes back in a week smells like a memory leak to me. The release notes for SP...
September 7, 2006 at 8:36 pm
Maybe I'm being an idiot, what do you do with an img file? My PC tried to treat it as a graphics file. I was guessing it was an error...
June 27, 2006 at 1:22 pm
In case you haven't seen it, this is the KB for configuring DTC on a Win2003 cluster.
http://support.microsoft.com/kb/301600/en-us
good luck
January 17, 2006 at 10:08 am
We have had add behavior with DTC in my shop too. As a matter of practice, DTC is in the same resource group as the quorum disk. When we move...
January 15, 2006 at 8:51 pm
If you haven't already, run dbcc checkdb on all the databases on that server. I would do this before opening a ticket with MS because it'll be one of the...
January 15, 2006 at 8:42 pm
Viewing 15 posts - 121 through 135 (of 137 total)