Forum Replies Created

Viewing 15 posts - 991 through 1,005 (of 1,518 total)

  • RE: Operations Manager Custom Collection

    Grant Fritchey (8/12/2008)

    I'm sorry the article wasn't clear enough on these points. I was really hoping to help people who had been stuck like I was. It seems I may...

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

    August 12, 2008 at 8:03 am

    #856713

  • RE: Operations Manager Custom Collection

    SQLEngine (8/11/2008)

    I think I've completed the swearing part... how are you reporting on this? Are you using Performance canned reports in Reporting space?

    Sorry, I meant that I figured out how...

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

    August 11, 2008 at 10:08 am

    #856211

  • RE: Operations Manager Custom Collection

    Marios Philippopoulos (8/9/2008)

    In the article, does the rule output data to the Event Log?

    If not, how can I get a rule to do so?

    Thanks!

    Actually I figured it out after 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]

    August 10, 2008 at 6:34 pm

    #855841

  • RE: Operations Manager Custom Collection

    In the article, does the rule output data to the Event Log?

    If not, how can I get a rule to do so?

    Thanks!

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

    August 9, 2008 at 5:40 am

    #855670

  • RE: Operations Manager Custom Collection

    SQLEngine (8/8/2008)

    Marios, I agree completely. I've had some "challenges" dealing with MS support as well, and have found lack of documentation and expertise... So that's why these posts, blogs, forums...

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

    August 9, 2008 at 4:45 am

    #855660

  • RE: Operations Manager Custom Collection

    Grant Fritchey (8/8/2008)

    Yeah, that's pretty common. We have a Microsoft consultant who comes in on site to help us with OM issues. I showed him what I was doing 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]

    August 8, 2008 at 10:42 am

    #855386

  • RE: Operations Manager Custom Collection

    Grant Fritchey (8/8/2008)

    Thanks. I'm glad it was at all helpful. Keep an eye out for Thomas LaRock articles too. I know he's got a new one coming becuase he let...

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

    August 8, 2008 at 10:31 am

    #855381

  • RE: Operations Manager Custom Collection

    Grant Fritchey (6/5/2008)

    Thanks guys. I realize it's kind of an obscure topic, but I had such a hard time tracking down the individual pieces of information that I felt compelled...

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

    August 7, 2008 at 7:27 pm

    #854863

  • RE: Ops Mgr 2007 (SCOM) question: need to enhance alert description for Blocked SPIDs Monitor

    No takers?

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

    August 7, 2008 at 5:58 pm

    #854836

  • RE: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server conn "

    Vivien Xing (8/3/2008)

    Another addict seeks advice here.

    Marios, how did you resolve your problem? Does Microsoft help you anyhow? Any story to share?

    I encountered the same problem and 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]

    August 4, 2008 at 4:56 am

    #852599

  • RE: Suggestion on Updating Statistics

    GilaMonster (8/2/2008)

    Marios Philippopoulos (8/2/2008)

    FULL SCAN, though it works to alleviate production issues, is a maintenance nightmare. One cannot run it on the whole database all the time because it will...

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

    August 2, 2008 at 5:52 am

    #852305

  • RE: Suggestion on Updating Statistics

    Grant Fritchey (8/2/2008)

    And that's why we've only had to do the FULL SCAN in a few places and on a somewhat irregular basis. Most indexes, most of the time, 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]

    August 2, 2008 at 5:23 am

    #852303

  • RE: Query hangs when inside a transaction, completes fine when not in a transaction

    i6004835 (8/1/2008)

    I'm not quite sure also about SQLDMO_1. But it seems from other posts in the internet to be a system process. Some say that It is linked with Enterprise...

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

    August 2, 2008 at 5:18 am

    #852301

  • RE: Suggestion on Updating Statistics

    GilaMonster (8/1/2008)

    Possibly more accurate to say, "If Rows Sampled is much less than Rows and you are dealing with a large table and you have a non-uniform data distribution,...

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

    August 1, 2008 at 1:15 pm

    #852146

  • RE: 2005 RAID Config

    Don't forget about tempdb! Place tempdb data files in their own independent physical array, if possible. This may be more critical than RAID 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]

    August 1, 2008 at 1:14 pm

    #852142

Viewing 15 posts - 991 through 1,005 (of 1,518 total)