Forum Replies Created

Viewing 15 posts - 616 through 630 (of 1,518 total)

  • RE: Server becomes very slow [RESOURCE_SEMAPHORE] waittype.

    TheSQLGuru (10/24/2008)

    Can you please tell us which bug it was in CU9 that was causing the problem? I checked and cannot find any FIX from that update dealing with...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 13, 2009 at 7:24 am

    #993690

  • RE: Understanding Execution Plans

    Not sure if this was mentioned in this thread, but are index stats up-to-date and is index fragmentation at low levels?

    The optimizer can make the wrong choices if stats is...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 12, 2009 at 6:33 pm

    #993363

  • RE: NULL Cached Query Plan for stored procedure

    I will talk to the developers about the way this has been coded. Doesn't look like the cursor and dynamic SQL are strictly necessary, although it is not easy to...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 11, 2009 at 10:42 am

    #992311

  • RE: NULL Cached Query Plan for stored procedure

    Grant Fritchey (5/10/2009)

    ...

    So, you said it was a very large query. Is it dynamically building strings that might exceed 8kb?

    It's also possible that it can't show the plan in XML...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 11, 2009 at 9:40 am

    #992230

  • RE: NULL Cached Query Plan for stored procedure

    Here is the plan (see attached). I have tried to obfuscate object names as much as possible, and, in doing so, I hope I have not messed up anything system-specific.

    Here...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 11, 2009 at 9:19 am

    #992210

  • RE: NULL Cached Query Plan for stored procedure

    andrew gothard (5/9/2009)

    Marios Philippopoulos (5/8/2009)

    Grant Fritchey (5/8/2009)

    Actually, if it's still in sys.dm_exec_sql_text and in sys.dm_exec_query_stats, then it's still in cache. It hasn't aged out yet. If it were not in...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 9, 2009 at 3:51 pm

    #991682

  • RE: NULL Cached Query Plan for stored procedure

    andrew gothard (5/9/2009)

    Marios Philippopoulos (5/8/2009)

    Grant Fritchey (5/8/2009)

    Actually, if it's still in sys.dm_exec_sql_text and in sys.dm_exec_query_stats, then it's still in cache. It hasn't aged out yet. If it were not in...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 9, 2009 at 3:46 pm

    #991681

  • RE: NULL Cached Query Plan for stored procedure

    Grant Fritchey (5/8/2009)

    Actually, if it's still in sys.dm_exec_sql_text and in sys.dm_exec_query_stats, then it's still in cache. It hasn't aged out yet. If it were not in cache, then not only...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 8, 2009 at 1:11 pm

    #991412

  • RE: How can I get an Execution Plan into a table column?

    Grant Fritchey (5/8/2009)

    Largely... What Gail said.

    The only way you can get the actual execution plan on the fly is to use a trace.

    It would have been great if SQL Server...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 8, 2009 at 10:50 am

    #991302

  • RE: NULL Cached Query Plan for stored procedure

    Grant Fritchey (5/8/2009)

    How long since the last execution did you query the dmv's? If it's hours or minutes, you may have a serious memory issue. If it's days or weeks......

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 8, 2009 at 10:43 am

    #991296

  • RE: NULL Cached Query Plan for stored procedure

    andrew gothard (5/7/2009)

    No, plans get aged out if there is no more memory available in plan cache due to the need to hold plans for more recently used queries. ...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 8, 2009 at 7:17 am

    #991044

  • RE: Runaway CHECKPOINT session on SQL-2008 db-engine instance

    David Benoit (5/5/2009)

    Nope, should be just one unless you execute one specifically 🙂 . The checkpoint should occur pretty quickly as noted in the one perfmon counter earlier discussed. If...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 5, 2009 at 10:57 am

    #989043

  • RE: Runaway CHECKPOINT session on SQL-2008 db-engine instance

    SQLBOT (5/4/2009)

    Sorry,

    I fell asleep at the wheel on this thread.

    The checkpoint process should always be running somewhere, or in the state 'checkpoint wait'

    There are many activities that automatically initiate a...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 5, 2009 at 9:57 am

    #988988

  • RE: Cached query plans - getting parameter values for which a specific plan was compiled

    GilaMonster (5/4/2009)

    Marios Philippopoulos (5/4/2009)

    It's odd, this proc is taking 3 input params, I just don't see why this portion is not listed.

    Not sure either. I just hauled a plan out...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 4, 2009 at 3:52 pm

    #988448

  • RE: Cached query plans - getting parameter values for which a specific plan was compiled

    GilaMonster (5/4/2009)

    Don't suppose you can post the exec plan for the proc you're struggling with?

    I'd love to but don't want to get in trouble. 🙂

    It's odd, this proc is...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 4, 2009 at 2:49 pm

    #988410

Viewing 15 posts - 616 through 630 (of 1,518 total)