Forum Replies Created

Viewing 15 posts - 856 through 870 (of 1,518 total)

  • RE: Checkpoint frequency: is it possible to configure at database level?

    GilaMonster (11/3/2008)

    Marios Philippopoulos (11/3/2008)

    Yes, we have collected these perfmon counters, and from the values it appears there is indeed latency in the PROD-SAN drive.

    Surprise surprise (not). Is it sharing drives...

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

    November 3, 2008 at 9:36 am

    #893089

  • RE: Checkpoint frequency: is it possible to configure at database level?

    TheSQLGuru (11/3/2008)

    perf mon counters avg disk sec/read and avg disk sec/write for each individual drives should reveal such performance problems, as would examining the virtual files stats DMV (or fn_virtualfilestats,...

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

    November 3, 2008 at 9:23 am

    #893083

  • RE: Checkpoint frequency: is it possible to configure at database level?

    I should mention that, after moving the LOG file of the target db to a LUN physically located on the TEST SAN, performance was drastically improved from 12 to 6...

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

    November 3, 2008 at 8:12 am

    #893029

  • RE: Checkpoint frequency: is it possible to configure at database level?

    Thanks all, after reading through your replies, it doesn't seem worth it fiddling with the checkpoint frequency.

    After more detailed analysis, this looks very much like a disk-performance (contention) issue.

    As I...

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

    November 2, 2008 at 3:13 pm

    #892856

  • RE: Checkpoint frequency: is it possible to configure at database level?

    TheSQLGuru (10/31/2008)

    recovery interval is a server level setting and cannot (to my knowledge) be configured for databases independently.

    Thanks, how can I configure it at the server level?

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

    October 31, 2008 at 1:03 pm

    #892538

  • RE: Memory Performance Monitor

    usman.tanveer (10/31/2008)

    Thanks alot, this certainly is very useful information. Now what about 64 BIT? i am assuming that AWE is not required for 64 BIT, so how can i monitor...

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

    October 31, 2008 at 10:37 am

    #892462

  • RE: AWE enabled yes or no?

    gah (10/31/2008)

    Thanks for the reply Marios

    - enable AWE to max memory of 4 GB, to enable the data buffer of your SQL instance to 'see' 4 GB of memory 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]

    October 31, 2008 at 3:44 am

    #892210

  • RE: Memory Performance Monitor

    usman.tanveer (10/30/2008)

    I have assinged max memory to 7 GB, so how can it be using 3 or 2 GB at max?

    More over how can i find which switch 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]

    October 30, 2008 at 6:31 pm

    #892130

  • RE: AWE enabled yes or no?

    gah (10/30/2008)

    Apologies if I should have created a new topic....

    Having read thro this thread and a multitude of others on here and elsewhere, I must confess to still being confused....

    We...

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

    October 30, 2008 at 1:14 pm

    #892061

  • RE: Memory Performance Monitor

    usman.tanveer (10/30/2008)

    I am on 32Bit, but i am not using AWE option.

    Then you are using at most 3 GB (if you have the 3-gb switch enabled) or 2 GB (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]

    October 30, 2008 at 11:58 am

    #892021

  • RE: Checkpoint frequency: is it possible to configure at database level?

    happycat59 (10/29/2008)

    First - is the migration of data occurring in a single database transaction or multiple ? If it is a single transaction then you should expect that your...

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

    October 30, 2008 at 4:33 am

    #891675

  • RE: Memory Performance Monitor

    usman.tanveer (10/29/2008)

    My Problem is different......i have set the MAX MEMORY variable of SQL Server to 7GB. Now i want to know that out of this 7GB MAX MEMORY, how much...

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

    October 29, 2008 at 2:36 pm

    #891486

  • RE: SPROC with variables runs like a dog compared to same SPROC with constants - why?!

    The best medicine for parameter sniffing (in my experience) is a "UPDATE STATISTICS tblName WITH FULLSCAN" on all (large) tables involved.

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

    October 29, 2008 at 2:34 pm

    #891484

  • RE: Memory Performance Monitor

    The memory SQL server is currently consuming is not readily available, but you can get info on this indirectly by this counter:

    Memory:Available Bytes

    This is the memory available to new processes....

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

    October 29, 2008 at 2:27 pm

    #891480

  • RE: CXPACKET wait type

    Also, gather some of your largest tables, those most actively queried in your system.

    Do "sp_helpindex tblName" to get a list of indexes for each table.

    Run "DBCC SHOW_STATISTICS ('tblName', 'idxName')" on...

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

    October 22, 2008 at 6:11 pm

    #888423

Viewing 15 posts - 856 through 870 (of 1,518 total)