Forum Replies Created

Viewing 15 posts - 721 through 735 (of 1,518 total)

  • RE: Costly update trigger -70,000,000 logical reads for 30,000 rows updated!

    Jeff Moden (2/1/2009)

    Marios Philippopoulos (2/1/2009)

    RBarryYoung (1/31/2009)

    Marios Philippopoulos (1/31/2009)

    I have a trigger that appears to execute a very large number of logical reads; on one occasion it has hit 73,421,728 logical...

    __________________________________________________________________________________
    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 1, 2009 at 1:12 pm

    #936196

  • RE: Costly update trigger -70,000,000 logical reads for 30,000 rows updated!

    RBarryYoung (2/1/2009)

    Marios, I think that what you gav eus before was the estimated execution plan. Can you get us the actual execution plan? IT should also be avaialable...

    __________________________________________________________________________________
    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 1, 2009 at 1:08 pm

    #936195

  • RE: Costly update trigger -70,000,000 logical reads for 30,000 rows updated!

    GilaMonster (2/1/2009)

    Can you perhaps post the trigger code?

    Sure, here it is. I had posted this code in a previous posting (http://www.sqlservercentral.com/Forums/Topic630749-360-4.aspx), and you had correctly pointed out that some of...

    __________________________________________________________________________________
    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 1, 2009 at 5:51 am

    #936140

  • RE: Costly update trigger -70,000,000 logical reads for 30,000 rows updated!

    Thanks guys for your responses.

    I should clarify that this is not a one-off event.

    Whenever the trigger is executed, the number of reads is always in the millions, while 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]

    February 1, 2009 at 5:15 am

    #936137

  • RE: Costly update trigger -70,000,000 logical reads for 30,000 rows updated!

    RBarryYoung (1/31/2009)

    Marios Philippopoulos (1/31/2009)

    I have a trigger that appears to execute a very large number of logical reads; on one occasion it has hit 73,421,728 logical reads!

    Is this for 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]

    February 1, 2009 at 5:09 am

    #936135

  • RE: Costly update trigger -70,000,000 logical reads for 30,000 rows updated!

    Here is the correct exec plan (attached)

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

    January 31, 2009 at 7:04 pm

    #936074

  • RE: Is my clustered index in need of a rebuild?

    matt stockham (1/30/2009)

    You may be fine, but it depends on the workload.

    Because SQL is reading an extent at a time from disk, you wouldn't want the average fragment...

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

    January 30, 2009 at 12:42 pm

    #935798

  • RE: Is 10.0.1600.22 the latest build of SQL 2008?

    DavidB (1/30/2009)

    If I was migrating to SQL Server 2008 I would try to start out as high as I could so that I didn't have to do it after 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]

    January 30, 2009 at 8:59 am

    #935627

  • RE: Is 10.0.1600.22 the latest build of SQL 2008?

    DavidB (1/30/2009)

    Not to direct things away from this site but the coverage at the following link is excellent as well.

    http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

    Thank you!

    Which version would you guys recommend?

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

    January 30, 2009 at 8:51 am

    #935618

  • RE: Is 10.0.1600.22 the latest build of SQL 2008?

    Ramesh (1/30/2009)

    Actually, the latest build is 10.00.1787.00

    See this article SQL Server 2008 Build List[/url] on this site

    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]

    January 30, 2009 at 8:43 am

    #935606

  • RE: Migration to SS 2008

    David Kranes (1/29/2009)

    Hello, I am upgrading an application from SQL Server 2000 to SQL Server 2008 and I need a good resource that will outline all the known issues 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]

    January 29, 2009 at 3:55 pm

    #935157

  • RE: Filegroups and log files

    huscyp (1/29/2009)

    thanks.It was clear.

    SO lets take an example , where our database will be 2TB very soon and there are some tables which will be very big.how we should divide...

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

    January 29, 2009 at 3:03 pm

    #935122

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

    Harold Buckner (1/28/2009)

    How hard of a change would it be to add the blocking User info.

    For example we have the blocking spid and the blocked spid and we have...

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

    January 29, 2009 at 3:54 am

    #934495

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

    Nilesh Patel (1/28/2009)

    I was able to find answer on how to set alert for specific monitor. It needs to be done using script as mentioned in

    http://blogs.msdn.com/jakuboleksy/archive/2007/01/18/notification-subscriptions.aspx

    We did not feel...

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

    January 29, 2009 at 3:44 am

    #934494

  • RE: Function that returns rowset, to feed a loop cycling through rows

    matt stockham (1/28/2009)

    I added the -h parameter to sqlcmd to drop headers. You also need to set nocount or parse out the returned values to only return valid instances....

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

    January 29, 2009 at 3:40 am

    #934492

Viewing 15 posts - 721 through 735 (of 1,518 total)