Forum Replies Created

Viewing 15 posts - 1,261 through 1,275 (of 2,640 total)

  • RE: MSSQLSERVER service terminated unexpectedly

    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/

  • RE: Missing transactions in our ERP

    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/

  • RE: Tools for monitoring

    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/

  • RE: SQL DTS package failure

    ?

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • RE: MSSQLSERVER service terminated unexpectedly

    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/

  • RE: Is it possible to identify the other process in a deadlock after it has happened?

    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/

  • RE: Urgent performance problems

    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/

  • RE: regarding service pack

    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/

  • RE: Restore Log Error Handling

    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/

  • RE: When can you run DBCC Updateusage(0)

    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/

  • RE: Database file sizes over 300GB

    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/

  • RE: Need explanation on Performance Monitor PhysicalDisk(*)\Avg. Disk sec/Transfer

    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/

  • RE: Urgent performance problems

    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/

  • RE: Urgent performance problems

    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/

  • RE: Failover not happeing

    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/

Viewing 15 posts - 1,261 through 1,275 (of 2,640 total)