Forum Replies Created

Viewing 15 posts - 466 through 480 (of 1,518 total)

  • RE: Missing Indexes in SQL Server 2005

    srawant (6/22/2010)

    Am I understanding differently or is it the fact that to have a view on the missing indexes we gotta run the query first ? If so would it...

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

    June 22, 2010 at 3:09 pm

    #1183612

  • RE: Pros and Cons of XML storage in SQL Server

    lmu92 (6/16/2010)

    We're using XML files only for getting data from a DB2 into SQL Server through a (required) 3rd party middleware.

    The reason we're using XML is to be flexible 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]

    June 17, 2010 at 11:11 am

    #1181728

  • RE: Duration of querying sys.dm_db_index_physical_stats on my database varies from seconds to an hour!

    Grant Fritchey (6/15/2010)

    Yes, it's absolutely possible that you're seeing contention. That much contention though would be a bit concerning. What is running on the systems that could block a shared...

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

    June 15, 2010 at 7:28 am

    #1180400

  • RE: Mirroring connection timeout for db

    Brandie Tarvin (6/14/2010)

    Are your servers within the same domain and both inside the firewall?

    If not, is your firewall open to the ports being used in the mirroring?

    Both servers are 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]

    June 14, 2010 at 12:09 pm

    #1180034

  • RE: Mirroring connection timeout for db

    Robert Davis (6/11/2010)

    That's not an error message. Every time you create a snapshot, it has to run crash recovery on the snapshot because it may have transactions in progress when...

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

    June 11, 2010 at 12:39 pm

    #1179384

  • RE: Mirroring connection timeout for db

    Robert Davis (6/10/2010)

    Your timeout value should NOT be getting reset when the mirror fails over. What is your SQL version/build #?

    You can change the timeout value in any mode, but...

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

    June 11, 2010 at 10:52 am

    #1179322

  • RE: Mirroring connection timeout for db

    One more question: can the default mirroring timeout be modified even when in High-Performance (Async) mode?

    On BOL it is stated that it can only be changed from the 10-sec default...

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

    June 9, 2010 at 10:27 am

    #1178097

  • RE: Mirroring connection timeout for db

    Brandie Tarvin (6/9/2010)

    Best way to be sure, though, is to create a job that updates that value and the job runs on the startup of SQL Agent Service.

    Thank you,...

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

    June 9, 2010 at 4:29 am

    #1177891

  • RE: Mirroring connection timeout for db

    Brandie Tarvin (4/29/2010)

    dallas13 (4/29/2010)

    I was able to see the improvements after this. It worked for me.

    But every time after failover this value again gets set to 10 sec

    so you need...

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

    June 8, 2010 at 9:26 pm

    #1177774

  • RE: Database Mirroring - steps on reinstating mirroring after network failure

    ALZDBA (6/7/2010)

    We've has some connection losses to, but the mirroring (primary-mirror-witness) resumed as soon as the connection could be reactivated between principal and mirror.

    It caught up very well (sql2005 std)

    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]

    June 7, 2010 at 3:25 pm

    #1177242

  • RE: 12(!) cached execution plans for the same stored procedure in production database

    GilaMonster (6/4/2010)

    Interesting.

    What I suggest is that you go through all of the attributes in sys.dm_exec_plan_attributes, one of the columns in there is 'is_cache_key'. If any attributes with that column =...

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

    June 4, 2010 at 11:36 am

    #1176662

  • RE: 12(!) cached execution plans for the same stored procedure in production database

    Sure, pls give me some time to get you the info, 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]

    June 4, 2010 at 10:32 am

    #1176631

  • RE: 12(!) cached execution plans for the same stored procedure in production database

    GilaMonster (6/4/2010)

    What does this return? Should be safe to post, there's no info on the query or plan anywhere in there.

    SELECT cp.plan_handle, cp.cacheobjtype, cp.refcounts, cp.usecounts,

    pa.attribute, pa.value

    FROM sys.dm_exec_cached_plans cp

    CROSS APPLY...

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

    June 4, 2010 at 9:55 am

    #1176606

  • RE: 12(!) cached execution plans for the same stored procedure in production database

    Cacheobjtype for all plans is "Compiled Plan".

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

    June 4, 2010 at 9:11 am

    #1176585

  • RE: 12(!) cached execution plans for the same stored procedure in production database

    GilaMonster (6/4/2010)

    Are all 12 plan handles different?

    Could you perhaps attach the results as an excel sheet? Without seeing results, hard to tell you why there are multiple rows. Can you...

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

    June 4, 2010 at 8:59 am

    #1176577

Viewing 15 posts - 466 through 480 (of 1,518 total)