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.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
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....
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
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...
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
February 20, 2007 at 5:53 am
?
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
February 20, 2007 at 5:43 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...
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
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...
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
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...
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
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...
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
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...
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
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...
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
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...
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
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...
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
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...
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
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...
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
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...
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
February 16, 2007 at 5:54 am
Viewing 15 posts - 1,261 through 1,275 (of 2,640 total)