Viewing 15 posts - 1,261 through 1,275 (of 2,640 total)
hmm .. and nothing in the windows event logs?
When the server is up have you done a sweep of checkdb etc.
February 20, 2007 at 12:51 pm
I'm sorry but experience tells me that the statement ( it's not a bug in our ERP ) is missguided, especially as you're getting deadlocks which are an application issue....
February 20, 2007 at 5:59 am
the forum has a section on third party tools - I use sql diagnostic manager, have done for about 8 or 9 years, it handles all this effortlessly and allows...
February 20, 2007 at 5:53 am
sql server doesn't normally stop and restart without some kind of message. What is reported in the event and sql logs?
Do you have any dmp files created, they'll be...
February 20, 2007 at 5:42 am
If deadlocks are a problem then enabling trace flags will store all the data you need in the sql log, but you do get large logs so need to use...
February 20, 2007 at 5:38 am
I keep pointing out that the sql performance memory recommendations are not complete. As with all things it just depends, but the /3gb switch can give problems. Read Ken Henderson's...
February 20, 2007 at 1:40 am
you should be aware that if you're using awe memory you need an additional patch, and, there are I'm told issues with sp4, you might want to apply rollup 2187...
February 19, 2007 at 7:37 am
if you have them in a loop it should carry on regardless, the other way is to work out which is the next log to be restored thus avoiding the...
February 19, 2007 at 7:35 am
dbccc updateusage is usually pretty quick to run and isn't as much of a problem as other dbcc commands. I run this daily on every database, but at the quietest...
February 19, 2007 at 7:31 am
it only becomes a problem if you find it a problem, one person's large database is another's small?
Using multiple devices increases complexity, as does multiple filegroups. Litespeed will make short...
February 19, 2007 at 7:29 am
this counter shows the average time it takes an io to complete in ms.
If you choose physical disk then I guess you'll get one value, if you choose logical then...
February 19, 2007 at 7:22 am
this is not true with awe. as far as I am sure , memeory is not swapped out with awe, once taken it's kept. Again this is documented in ms...
February 16, 2007 at 12:08 pm
you generally don't need to increase the page file size on a sql server as sql server is designed not to page. You might try removing the /3gb switch, I've...
February 16, 2007 at 6:14 am
my experience is that a mail client won't stop a failover. I assume you're using cluster admin to achieve this?
As posted above you need to set the outlook client on...
February 16, 2007 at 5:54 am
Viewing 15 posts - 1,261 through 1,275 (of 2,640 total)