Forum Replies Created

Viewing 15 posts - 841 through 855 (of 1,518 total)

  • RE: Strategies for persisting linked-server configurational information outside of the SQL instance

    Michael Earl (11/10/2008)

    I can see that, but I would not go overboard on this one.

    They probably are not changing daily. I would script them, not allow them to be...

    __________________________________________________________________________________
    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 10, 2008 at 1:47 pm

    #896553

  • RE: Strategies for persisting linked-server configurational information outside of the SQL instance

    Michael Earl (11/10/2008)

    Is your linked server environment that large and constantly changing? I would think source control for the changes would be overkill, but I suppose if you 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]

    November 10, 2008 at 12:29 pm

    #896506

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

    Harold Buckner (11/7/2008)

    how stupid of me. I kept going though the script and finally hit me to check the permission on the procedure. I grant execute on my db role...

    __________________________________________________________________________________
    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 7, 2008 at 6:48 pm

    #895896

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

    Harold Buckner (11/7/2008)

    I used the zipped files link from the article. Are the one posted here different?

    Actually, they should be the same, my bad, it's been a while since 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 7, 2008 at 4:53 pm

    #895877

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

    Harold Buckner (11/7/2008)

    Hi Marios

    I like the way you handled this task and the great information it provides. However, I had some errors on the 2000 script thats making me do...

    __________________________________________________________________________________
    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 7, 2008 at 4:12 pm

    #895866

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

    Harold Buckner (11/7/2008)

    Hi Marios

    I like the way you handled this task and the great information it provides. However, I had some errors on the 2000 script thats making me do...

    __________________________________________________________________________________
    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 7, 2008 at 2:42 pm

    #895839

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

    TheSQLGuru (11/6/2008)

    I must have missed the smiley that indicated you were joking. As for resources required, the main issue with that statement is that almost everyone simply uses SIZE...

    __________________________________________________________________________________
    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 6, 2008 at 11:34 am

    #895114

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

    TheSQLGuru (11/6/2008)

    Marios Philippopoulos (11/6/2008)

    Would all 1024 drives be 'seen' by the same SQL server instance and shared by all other SQL instances? How does that help with IO throughput? Isn't...

    __________________________________________________________________________________
    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 6, 2008 at 9:56 am

    #895039

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

    I'm by no means a SAN expert but it seems from what you guys are saying that in the case where a SAN's resources far outnumber the resources actually required...

    __________________________________________________________________________________
    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 6, 2008 at 9:42 am

    #895027

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

    Would all 1024 drives be 'seen' by the same SQL server instance and shared by all other SQL instances? How does that help with IO throughput? Isn't contention a problem...

    __________________________________________________________________________________
    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 6, 2008 at 9:24 am

    #895009

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

    TheSQLGuru (11/6/2008)

    Marios Philippopoulos (11/6/2008)

    How is SAN architecture in any way beneficial to SQL Server performance?

    1) Can you have 1024 drives direct attached effectively? You can do that with 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]

    November 6, 2008 at 8:58 am

    #894966

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

    How is SAN architecture in any way beneficial to SQL Server performance?

    __________________________________________________________________________________
    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 6, 2008 at 8:39 am

    #894942

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

    Jeff Moden (11/5/2008)

    Heh... good luck.

    Thanks! I hate SANs, wish we could run SQL Server on desktops... 😉

    __________________________________________________________________________________
    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 6, 2008 at 3:54 am

    #894748

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

    TheSQLGuru (11/4/2008)

    Jeff Moden (11/4/2008)

    Then you should probably split it up... doing an update on something that large all at once will probably drive your code past the "tipping point" that...

    __________________________________________________________________________________
    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 5, 2008 at 7:33 am

    #894232

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

    Jeff Moden (11/3/2008)

    Marios Philippopoulos (10/29/2008)

    I'm having a performance problem, while migrating a large amount of data from one database to another within the same SQL instance.

    The main wait type 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]

    November 4, 2008 at 8:33 am

    #893665

Viewing 15 posts - 841 through 855 (of 1,518 total)