Forum Replies Created

Viewing 15 posts - 391 through 405 (of 5,841 total)

  • RE: Queries Hung on Memory Request

    Stamey - Thursday, February 23, 2017 5:56 AM

    1. The server is Enterprise Edition. I would love to give the server more RAM,...

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

    February 23, 2017 at 7:22 am

    #1929943

  • RE: Issue with query

    mcfarlandparkway - Wednesday, February 22, 2017 5:19 PM

    I have a table where I am trying to write a query in SSIS package...

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

    February 22, 2017 at 5:29 pm

    #1929876

  • RE: Queries Hung on Memory Request

    Stamey - Wednesday, February 22, 2017 2:05 PM

    Server is an x64 VM with Win 2012 and SQL 2012, SP3. It has 32G...

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

    February 22, 2017 at 3:58 pm

    #1929871

  • RE: SPID Status SUSPENDED with MaxDOP = 1? I need to look back...

    Waits can be viewed at an aggregate level on the server, and on an individual basis for executing queries. Duration and worker time and IO are tracked for query executions....

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

    February 22, 2017 at 10:32 am

    #1929788

  • RE: Compare two sets of data

    Guessing here, but I think you want a FULL OUTER JOIN on Last Name, First Name and Product Name (QualityType is a possibility too I suppose). You can filter after...

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

    February 21, 2017 at 4:11 pm

    #1929639

  • RE: Performance improves after reboot

    We are still just flopping and twitching here on the forum, and are no closer to a resolution. Some likely final comments:

    1) shrinking tempdb cannot possibly help improve...

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

    February 21, 2017 at 1:28 pm

    #1929604

  • RE: Memory Problem: Low buffer cache,low PLE, but High free page

    That is the SQL Server build number. You are 14 months behind as CU7 for SP3, build 6579, was released Jan 17, 2017. It is absolutely possible that you have memory...

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

    February 21, 2017 at 12:50 pm

    #1929596

  • RE: Memory Problem: Low buffer cache,low PLE, but High free page

    There's a lot more to dbcc memorystatus than what you posted. What did your review of the documentation online reveal? 

    https://support.microsoft.com/en-us/help/907877/how-to-use-the-dbcc-memorystatus-command-to-monitor-memory-usage-on-sql-server-2005

    Also review this:

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

    February 21, 2017 at 11:54 am

    #1929582

  • RE: Memory Problem: Low buffer cache,low PLE, but High free page

    graciez - Tuesday, February 21, 2017 10:50 AM

    Hi Kevin,

    Thanks for the quick reply. To answer your question:

    1) You posted this on SQL...

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

    February 21, 2017 at 11:07 am

    #1929575

  • RE: How to avoid cursors

    I will add that doing your activities one-at-a-time gives you control over error handling too, which other mechanisms that may put all of your code in one statement may not...

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

    February 21, 2017 at 10:07 am

    #1929565

  • RE: Deploying Scalar Function Across all DBs

    scarr030 - Tuesday, February 21, 2017 9:53 AM

    Thank you both for your input and help.

    TheSQLGuru - Tuesday, February...

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

    February 21, 2017 at 10:05 am

    #1929564

  • RE: Memory Problem: Low buffer cache,low PLE, but High free page

    1) You posted this on SQL 2012 forum, but I thought Free Pages went away in that version

    https://blogs.msdn.microsoft.com/vsanil/2012/11/21/did-some-performance-counters-like-free-pages-disappear-in-sql-2012/

    2) How is your IO amount and...

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

    February 21, 2017 at 10:00 am

    #1929563

  • RE: Optimizing a query

    Luis Cazares - Tuesday, February 21, 2017 6:12 AM

    This might work for a single read on the Contacts table, but I can't...

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

    February 21, 2017 at 9:49 am

    #1929559

  • RE: How to avoid cursors

    scarr030 - Tuesday, February 21, 2017 8:14 AM

    Hi All,

    I'm now the new accidental DBA. We have some non-prod DBs, but most of...

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

    February 21, 2017 at 9:44 am

    #1929556

  • RE: IO Performance Problem

    Sergiy - Tuesday, February 21, 2017 1:45 AM

    Could it be caused by DB file auto-grow?How much free space do you have in...

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

    February 21, 2017 at 9:38 am

    #1929555

Viewing 15 posts - 391 through 405 (of 5,841 total)