Forum Replies Created

Viewing 15 posts - 46 through 60 (of 1,518 total)

  • RE: AlwaysOn Availability-Groups Async replica - is it possible to restore log backups to it following a failover from primary replica

    jeff.mason (3/14/2013)

    If by "fail over" you mean start using, then no, you can't. A failover on an asynch setup will cause recovery to happen. Once a database recovers,...

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

    March 14, 2013 at 2:19 pm

    #1597264

  • RE: AlwaysOn Availability-Groups Async replica - is it possible to restore log backups to it following a failover from primary replica

    Anyone?

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

    March 14, 2013 at 12:33 pm

    #1597199

  • RE: Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts

    krn045 (1/21/2013)

    Hi..

    We are using SCOM 2007 to monitor SQL Server 2008 instances. I have checked the blocked sessions alert details in SCOM console as well as in OperationsManager database. 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]

    February 6, 2013 at 6:37 pm

    #1585174

  • RE: Preparing for the Unthinkable - a Disaster/Recovery Implementation

    JoeSchmoe007 (12/13/2012)

    This article is useful. However, this approach will not work well for logins if Windows authentication is used for some logins and primary and DR servers are not 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]

    December 14, 2012 at 4:35 am

    #1568643

  • RE: Question about included columns in nonclustered indexes: Where exactly are they stored?

    Kristian Ask (11/16/2012)

    I know it's an old topic but how is included columns affecting memory footprint? Some say higher use to put index in.memory cache. Some say lower since less...

    __________________________________________________________________________________
    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 17, 2012 at 10:28 am

    #1560013

  • RE: Erroneous results on last_execution_time, execution_count obtained from DMV sys.dm_exec_procedure_stats

    webwilliam (11/14/2012)

    Disregard my post. I ran a sp_recompile on my stored procedure to reset everything. Then when my job ran I saw the execution_count jump to 41.

    I then realized...

    __________________________________________________________________________________
    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 14, 2012 at 5:54 pm

    #1559193

  • RE: Erroneous results on last_execution_time, execution_count obtained from DMV sys.dm_exec_procedure_stats

    webwilliam (11/14/2012)

    I too am see the same thing. I have a job called every 15 minutes, but the execution_count is extremely higher. There is no way the execution_count is correct.

    Thank...

    __________________________________________________________________________________
    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 14, 2012 at 2:30 pm

    #1559130

  • RE: Managing Transaction Logs

    Thank you for the article.

    I found the section titled "How does SQL use the log?" particularly well written.

    I hope I am not the only one that feels this way,...

    __________________________________________________________________________________
    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 8, 2012 at 1:51 pm

    #1557350

  • RE: Erroneous results on last_execution_time, execution_count obtained from DMV sys.dm_exec_procedure_stats

    Any ideas on this anyone?

    __________________________________________________________________________________
    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 8, 2012 at 6:35 am

    #1557149

  • RE: Do people rebuild indexes if non-leaf levels exceed fragmentation threshold?

    Thanks both!

    I think I will incorporate this (>1,000 pages for intermediate levels) as a criterion for rebuilding indexes with avg frag > 30% (at the intermediate level in question).

    __________________________________________________________________________________
    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, 2012 at 7:16 am

    #1555754

  • RE: Do people rebuild indexes if non-leaf levels exceed fragmentation threshold?

    No comments? :crying:

    __________________________________________________________________________________
    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 1, 2012 at 10:47 am

    #1555107

  • RE: Getting wrong page count from sys.dm_db_index_physical_stats

    GilaMonster (10/30/2012)

    Probably not. The fragmented level is not 1000 pages, it's most likely going to be in memory. Maybe, if you're doing huge range scans that require SQL to read...

    __________________________________________________________________________________
    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, 2012 at 2:33 pm

    #1554383

  • RE: Getting wrong page count from sys.dm_db_index_physical_stats

    My fault, I was filtering on the following in the 1st query, but did not post that part in the opening post:

    WHERE

    F.avg_fragmentation_in_percent > 10

    AND F.page_count > 100

    As a result,...

    __________________________________________________________________________________
    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, 2012 at 1:56 pm

    #1554365

  • RE: Getting wrong page count from sys.dm_db_index_physical_stats

    GilaMonster (10/30/2012)

    As I said...

    You're looking at a nonclustered index in the first one (index id 9) and all indexes (clustered and nonclustered in the second)

    I added a filter in the...

    __________________________________________________________________________________
    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, 2012 at 1:04 pm

    #1554341

  • RE: Getting wrong page count from sys.dm_db_index_physical_stats

    GilaMonster (10/30/2012)

    You're looking at a nonclustered index in the first one (index id 9) and all indexes (clustered and nonclustered in the second)

    p.s. sys.sysindexes is deprecated, should not be used....

    __________________________________________________________________________________
    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, 2012 at 12:28 pm

    #1554321

Viewing 15 posts - 46 through 60 (of 1,518 total)