Forum Replies Created

Viewing 15 posts - 406 through 420 (of 5,841 total)

  • RE: Performance improves after reboot

    RVO - Tuesday, February 21, 2017 9:02 AM

    Hi Kevin,

    No. We didn't get "FIXED" Reservation for RAM yet.
    It's not going to be busy....

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

    February 21, 2017 at 9:36 am

    #1929554

  • RE: Deploying Scalar Function Across all DBs

    There are a number of tools available that will run scripts on multiple databases on multiple servers in one fell swoop. If you know scripting it is almost trivial, especially...

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

    February 21, 2017 at 9:30 am

    #1929552

  • RE: Optimizing a query

    ChrisM@home - Monday, February 20, 2017 1:00 PM

    Why not read the contacts table in one go?

    SET TRANSACTION ISOLATION LEVEL...

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

    February 20, 2017 at 3:06 pm

    #1929449

  • RE: High Disk Queue length

    sgmunson - Friday, February 17, 2017 1:15 PM

    TheSQLGuru - Tuesday, February 14, 2017 5:07 PM

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

    February 17, 2017 at 3:19 pm

    #1929213

  • RE: Performance improves after reboot

    RVO - Thursday, February 16, 2017 9:58 AM

    Kevin,
    I was running this query yesterday
    and notice every 2-3 minutes it returns record where granted_memory...

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

    February 17, 2017 at 3:18 pm

    #1929212

  • RE: Good or slow? 1 min to load 600M text format into SQL

    As other's have said REALLY efficient loading of very large amounts of data (and then presumably either processing it or using it as a fact table meaning you need additional...

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

    February 17, 2017 at 3:14 pm

    #1929211

  • RE: IO Performance Problem

    huntersimon - Friday, February 17, 2017 6:09 AM

    Its physical, problem has vanished again, still didn't figure out the root cause.  Thanks for...

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

    February 17, 2017 at 3:05 pm

    #1929210

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

    Eric Mamet - Thursday, February 16, 2017 2:26 AM

    >> "Does this actually matter for any purpose?"

    Yes, because this stored procedure is...

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

    February 16, 2017 at 4:08 am

    #1928793

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

    Eric Mamet - Wednesday, February 15, 2017 5:31 AM

    Tried it but does not make a difference to what I see in...

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

    February 15, 2017 at 9:29 pm

    #1928759

  • RE: HashKeys in OLTP system

    ajjarapumadhavi - Wednesday, February 15, 2017 11:50 AM

    Hello, 

    We are building a new OLTP system, where we can load data through files. In...

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

    February 15, 2017 at 9:24 pm

    #1928758

  • RE: Performance improves after reboot

    RVO - Wednesday, February 15, 2017 9:22 AM

    We reboot the whole server (Windows 2012 Server box).

    Yes, It's shared memory and I pointed...

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

    February 15, 2017 at 9:20 pm

    #1928756

  • RE: Performance improves after reboot

    RVO - Wednesday, February 15, 2017 8:10 AM

    Some clarification.

    It is VIRTUAL MACHINE.
    HYPERVISOR.
    We do have about 100 active SQL Server Agent jobs running:
    every...

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

    February 15, 2017 at 9:19 pm

    #1928755

  • RE: Performance improves after reboot

    RVO - Tuesday, February 14, 2017 9:07 PM

    So Jeff.
    Long story short.
    No multiple plans for the same query. Correct?

    something is driving...

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

    February 14, 2017 at 9:18 pm

    #1928541

  • RE: Query fills tempdb after upgrade from 2005 to 2012

    What stats did you create?

    Why did you decide to create those particular ones?

    Is auto-create statistics OFF on either or both servers?

    More important than the...

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

    February 14, 2017 at 8:38 pm

    #1928539

  • RE: Query fills tempdb after upgrade from 2005 to 2012

    jamie_collins - Tuesday, February 14, 2017 2:46 PM

    Sorry I didn't get a chance to update but I've managed to resolve the issue.
    This...

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

    February 14, 2017 at 5:16 pm

    #1928526

Viewing 15 posts - 406 through 420 (of 5,841 total)