Forum Replies Created

Viewing 15 posts - 421 through 435 (of 5,841 total)

  • RE: Where is that CPU gone? (Profiler Trace)

    My recollection is that Profiler will show the entire batch completion AFTER the completion of all statements in comprises. Thus your statement completed following the sp completed event should be...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 14, 2017 at 5:14 pm

    #1928525

  • RE: High Disk Queue length

    Admingod - Tuesday, February 14, 2017 10:24 AM

    After moving the Sql server to new hardware the CPU utilization dropped. However, the disk...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 14, 2017 at 5:07 pm

    #1928524

  • RE: Performance improves after reboot

    RVO - Tuesday, February 14, 2017 11:25 AM

    Jeff,

    Is Kevin G. Boles specialty - performance issues?
    What is the best way to contact Kevin?

    I...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 14, 2017 at 5:06 pm

    #1928523

  • RE: Performance improves after reboot

    RVO - Tuesday, February 14, 2017 4:02 PM

    Perry White,
    Can you please explain your comment below?
    What does it mean "when buffer pool recharges"?

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 14, 2017 at 5:01 pm

    #1928522

  • RE: In-Memory OLTP

    This has got to be pretty darn easy to do a POC for. Everything you need is in place. Just make a new sproc that is compiled and time that...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 14, 2017 at 9:59 am

    #1928412

  • RE: Adding an identity column & ensuring it is ordered by existing date column

    1) Don't forget to turn identity_insert back off when done! 🙂

    2) You may want to consider secondary sorts for the case where the date you are ordering by...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 13, 2017 at 10:01 pm

    #1928266

  • RE: SPROC Stored Proc vs SSIS for Enterprise Wide Dev

    ZZartin - Monday, February 13, 2017 2:30 PM

    There's nothing wrong with using SPROCS in SSIS, but you're correct if you have SSIS...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 13, 2017 at 9:59 pm

    #1928265

  • RE: Comparing Jobs list between AlwaysOn Replicas

    szejiekoh - Sunday, February 12, 2017 9:31 AM

    Hi Kevin,

    The link server will have to be created on a production and i am...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 12, 2017 at 7:10 pm

    #1928031

  • RE: Performance improves after reboot

    Thanks for the props Jeff!! 

    You bring up a good point though which is what patch level is the OP on. There are indeed memory leaks that have been...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 11, 2017 at 7:44 pm

    #1927972

  • RE: Comparing Jobs list between AlwaysOn Replicas

    szejiekoh - Friday, February 10, 2017 8:51 PM

    Hi all,
    As the topic goes, I am not referring to auto mated job syncing between...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 10, 2017 at 10:48 pm

    #1927929

  • RE: Performance improves after reboot

    RVO - Friday, February 10, 2017 7:56 PM

    SQLGuru,

    It was already set to the same size - 2GB and same Autogrowth 200MB
    once. Why...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 10, 2017 at 10:42 pm

    #1927928

  • RE: IO Performance Problem

    Use sp_whoisactive in differential mode to see the cumulative amount of work done by spids that run for the duration. I might try 30 or 60 seconds. Also use it...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 10, 2017 at 4:42 pm

    #1927913

  • RE: Performance improves after reboot

    1) Do you have traceflags 1117 and 1118 on? Best to have those I think to ensure optimal tempdb operations.

    2) I would basically redo the system if you...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 10, 2017 at 4:38 pm

    #1927912

  • RE: Performance improves after reboot

    RVO - Wednesday, February 8, 2017 10:38 PM

    I read this Brent Ozar article.
    It's a tutorial how to collect performance counters data and...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 9, 2017 at 2:51 pm

    #1927655

  • RE: Too many workers?

    Good news! Thanks for letting us know!

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    February 8, 2017 at 8:20 pm

    #1927431

Viewing 15 posts - 421 through 435 (of 5,841 total)