Forum Replies Created

Viewing 10 posts - 1 through 11 (of 11 total)

  • RE: Too many workers?

    TheSQLGuru - Tuesday, January 31, 2017 2:52 PM

    [...]
    Please do drop us a line about how things go after you are able...

    February 8, 2017 at 4:42 am

    #1927283

  • RE: Too many workers?

    Thanks for the quick reply Kevin.

    All our SQL Server are dedicated machines, the only other things that are running are what's needed to send logs and server statistics...

    January 31, 2017 at 2:27 pm

    #1925966

  • RE: Too many workers?

    Hi Sue,

    LOL, I know about "soon to be retired" taking much longer than expected - that is the case with our DB-01 server...   However, the new...

    January 31, 2017 at 12:48 pm

    #1925944

  • RE: Too many workers?

    TheSQLGuru - Tuesday, January 31, 2017 5:51 AM

    A) I don't think I ever said anything about blocking being an issue. It wouldn't...

    January 31, 2017 at 11:53 am

    #1925926

  • RE: Too many workers?

    Sue_H - Tuesday, January 31, 2017 7:04 AM

    You have no work queue count. There is nothing unreal about the miscellaneous work...

    January 31, 2017 at 11:47 am

    #1925924

  • RE: Too many workers?

    Sue_H - Monday, January 30, 2017 5:35 PM

    The queries you should run would be the same ones you would use to...

    January 31, 2017 at 4:06 am

    #1925795

  • RE: Too many workers?

    Eirikur Eiriksson - Tuesday, January 31, 2017 1:17 AM

    What about blocking and cost threshold for parallelism on the troubled server?
    😎

    Hi Eirikur,

    As...

    January 31, 2017 at 3:28 am

    #1925790

  • RE: Too many workers?

    TheSQLGuru - Monday, January 30, 2017 3:14 PM

    First off: If you want something fixed "now" you really need to get someone on...

    January 31, 2017 at 3:27 am

    #1925789

  • RE: Partitioned View problem on SQL 2012 R2 Std Ed.

    What I ended up doing was to create the logic in the SP that inserts/deletes data to know which partition it should insert into or delete from. I did not...

    October 15, 2015 at 7:00 am

    #1833469

  • RE: Partitioned View problem on SQL 2012 R2 Std Ed.

    Thank you very much for taking the time to run the scripts and test the resulting structure. It feels good to know that it works on other systems even though...

    October 15, 2015 at 1:52 am

    #1833381

Viewing 10 posts - 1 through 11 (of 11 total)