Forum Replies Created

Viewing 15 posts - 46 through 60 (of 381 total)

  • RE: MSDB Deadlock = Server crawl?

    I didn't really need to delete anything. That was an accident by one my co-workers when they dropped a database.

    The question I am trying to figure out here is...

  • RE: MSDB Deadlock = Server crawl?

    Yes, I am sure on the deadlocks. We have them written to the error log on a regular basis.

    How much are we talking here. I have...

  • RE: SQLVDI and then Terminate Unexpectedly

    Why?

    Fraggle

  • RE: SQLVDI and then Terminate Unexpectedly

    rudy - Doctor "X" (4/25/2012)


    a few questions ...

    How much RAM on the Windows side ?

    How much RAM is allocated to SQL Server ?

    Are you using any startup trace flags ?

    Are...

  • RE: SQLVDI and then Terminate Unexpectedly

    We have Litespeed set to "Verbose, cleanup on success" so I have stuff that Litespeed is looking into.

    The event logs don't show any restart errors.

    Fraggle.

  • RE: SQLVDI and then Terminate Unexpectedly

    Yup, pretty much.

    Fraggle.

  • RE: Execute Process Task Error (Wrapper)

    Actually, I figured it out. The error was more helpful than original thought.

    Error: The wrapper was unable to set the value of the variable specified in the ExecutionValueVariable property

    Hitting...

  • RE: Task was forced to yield

    Gail,

    Is there a way to find out which CLR is causing the issues? Both of the procs listed contain multiple CLR's.

    Additionally, just in general, how...

  • RE: Task was forced to yield

    Gila,

    Any idea how I can find this?

    Thanks,

    Fraggle

  • RE: Replication Error

    Jonathan Marshall (2/9/2012)


    When trying to View the Synchronization status of a database I'm looking to replicate I get an error stating. The database "DbName" cannot be opened. It is acting...

  • RE: Mirroring and SQL Agent Jobs

    Just an update on this. Restart the SQL Agent Service has stopped the issue from occuring. We still don't know why it occured in the first place. When...

  • RE: Mirroring and SQL Agent Jobs

    ALZDBA (2/6/2012)


    - are you monitoring dbmirroring events ? If not, you should implement that ! (see attachments )

    Your default trace file(s) may also help you to diagnose this issue...

  • RE: Mirroring and SQL Agent Jobs

    Jonathan Kehayias (2/6/2012)


    Post a script that would generate a repro in your environment and I'll see if I can do the same in mine.

    Here you go. Strait raw output...

  • RE: Mirroring and SQL Agent Jobs

    Fraggle-805517 (2/6/2012)


    Jonathan Kehayias (2/6/2012)


    If you created the job on ServerA and then scripted it out so that you could just run the script against Server B to create the job,...

  • RE: Mirroring and SQL Agent Jobs

    Jonathan Kehayias (2/6/2012)


    If you created the job on ServerA and then scripted it out so that you could just run the script against Server B to create the job, this...

Viewing 15 posts - 46 through 60 (of 381 total)