Forum Replies Created

Viewing 15 posts - 1,036 through 1,050 (of 1,518 total)

  • RE: Need help interpreting AWE perfmon counters

    colin Leversuch-Roberts (7/29/2008)

    well I think the official ms figure is 300 although I prefer a higher value. If the page life goes to zero then you're flushing the cache and...

    __________________________________________________________________________________
    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]

    July 29, 2008 at 3:21 pm

    #850163

  • RE: Need help interpreting AWE perfmon counters

    colin Leversuch-Roberts (7/29/2008)

    that's really the wrong set of data and question. Why do you think you don't have enough memory?

    I'd suggest you start with page life expectancy - this will...

    __________________________________________________________________________________
    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]

    July 29, 2008 at 9:26 am

    #849894

  • RE: Locate undo file of standby database

    GSquared (7/28/2008)

    Isn't that just the most recent log backup?

    No, the undo file contains info to recover the database, ie. undo uncommitted transactions.

    __________________________________________________________________________________
    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]

    July 29, 2008 at 8:59 am

    #849867

  • RE: Query hangs when inside a transaction, completes fine when not in a transaction

    Using the DBCC command, I find that the log space utilization for tempdb is about 43%, but, what do I do next?

    __________________________________________________________________________________
    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]

    July 29, 2008 at 4:33 am

    #849667

  • RE: Query hangs when inside a transaction, completes fine when not in a transaction

    jeffrey yao (7/28/2008)

    When serveral big inserts are combined in one transaction, there is a "hot" demand for the log space. Without "begin tran / commit tran", as soon as one...

    __________________________________________________________________________________
    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]

    July 29, 2008 at 4:15 am

    #849659

  • RE: Query hangs when inside a transaction, completes fine when not in a transaction

    I changed my post above to include a COMMIT TRAN (had a ROLLBACK TRAN earlier).

    Same outcome:

    With the transaction, the query completes in about 15 min.

    Without the transaction (with BEGIN...

    __________________________________________________________________________________
    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]

    July 28, 2008 at 7:06 pm

    #849540

  • RE: Query hangs when inside a transaction, completes fine when not in a transaction

    GilaMonster (7/28/2008)

    Will take a look tomorrow (if no one else solves it in the meantime, that is). Is past bed time here.

    No worries, it's much appreciated.

    __________________________________________________________________________________
    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]

    July 28, 2008 at 3:23 pm

    #849490

  • RE: Query hangs when inside a transaction, completes fine when not in a transaction

    Perfmon counter "Buffer Manager\Page life expectancy" is below 200. I think that indicates memory pressure as well.

    __________________________________________________________________________________
    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]

    July 28, 2008 at 3:17 pm

    #849484

  • RE: Query hangs when inside a transaction, completes fine when not in a transaction

    I'm also seeing a lot of SP:CacheRemove events in Profiler. Is the cache being flushed because of memory pressure?

    __________________________________________________________________________________
    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]

    July 28, 2008 at 2:57 pm

    #849469

  • RE: Query hangs when inside a transaction, completes fine when not in a transaction

    Also:

    We appear to be under phys. memory pressure on the server: RAM utilization is 14 GB (out of a total of 16 GB).

    The instance is configured with AWE (Lock working...

    __________________________________________________________________________________
    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]

    July 28, 2008 at 2:48 pm

    #849457

  • RE: Handling Tempdb space full situtation?

    Brandie Tarvin (7/28/2008)

    Definitely put together this utilization stuff for an article, please. That would be FANTASTIC.

    Thanks guys, I'm flattered.

    Will start work on the article! 😀

    __________________________________________________________________________________
    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]

    July 28, 2008 at 7:36 am

    #849181

  • RE: Oracle 10g versus sqlserver 2005

    Mazharuddin Ehsan (7/26/2008)

    My inputs based on working on both the dbs:

    1. SQL Server 2005 is eqally good as Oracle 10g in performance etc.

    2. The other parameters you can...

    __________________________________________________________________________________
    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]

    July 27, 2008 at 5:46 pm

    #848929

  • RE: Handling Tempdb space full situtation?

    TheSQLGuru (7/26/2008)

    Marios, could I trouble you for the table definitions for your system as well as the rdl for the report(s) you have? Looks like some very useful stuff...

    __________________________________________________________________________________
    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]

    July 27, 2008 at 5:01 am

    #848888

  • RE: Handling Tempdb space full situtation?

    This is a great link for identifying the various contributors to tempdb utilization:

    Working with tempdb in SQL Server 2005

    http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx#EX1AE

    Based on that link, I have created the following sproc that 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]

    July 25, 2008 at 4:03 pm

    #848719

  • RE: Check Named Pipes and TCP/IP on multiple servers

    Amit Chaudhary (7/24/2008)

    Hi,

    I have to check whether Named Pipes and TCP/IP is enabled or not on 89 SQL Servers ( all are 2005 ). I am planning to use sqlcmd....

    __________________________________________________________________________________
    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]

    July 25, 2008 at 3:30 pm

    #848713

Viewing 15 posts - 1,036 through 1,050 (of 1,518 total)