Forum Replies Created

Viewing 15 posts - 15,361 through 15,375 (of 19,560 total)

  • RE: Getting decent sql server performance despite a slow drive

    Marts (4/5/2010)


    Again thank you for all your replies.

    One point I must note here, we have only sql server standard, and unless I'm very much mistaken it is limited to 2gb...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Options for dealing with table Contention

    Paul White NZ (4/5/2010)


    CirquedeSQLeil (4/5/2010)


    "Adding more files and properly aligning them with storage can increase the I/O performance for a variety of reasons but achieving new I/O threads per file...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Down Tools Week

    Nice article Tony. I think this type of program has some extreme merits. I know what I would do under these types of circumstances.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Are the posted questions getting worse?

    Luke L (4/5/2010)


    GSquared (4/5/2010) I'm looking forward to the next installers, which will be either flash drives or something you download. BIOSes need to be able to fire up...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Getting decent sql server performance despite a slow drive

    Paul White NZ (4/5/2010)


    CirquedeSQLeil (4/5/2010)


    I agree with Paul here. A little more on the disk config: I would definitely leave the data RAID as RAID 5. Forego...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Options for dealing with table Contention

    Paul White NZ (4/5/2010)


    Only if you are experiencing allocation contention - which can still happen on...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Options for dealing with table Contention

    Garadin (4/5/2010)


    CirquedeSQLeil (4/5/2010)


    Garadin (4/5/2010)


    As of right now, our entire DB is in one file/filegroup. Would splitting this into multiple files provide any benefit in this regard? They'd all...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Answering to the Business

    I like the idea of transparency. If you are a consultant for a company - there is a degree of transparency there that is far greater than if you...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Getting decent sql server performance despite a slow drive

    Paul White NZ (4/5/2010)


    Marts (4/5/2010)


    Currently it is on Windows server 2000, is there any benefit in changing to 2003?

    Definitely, a big yes on that one, Martin.

    Way too many reasons to...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Options for dealing with table Contention

    Garadin (4/5/2010)


    As of right now, our entire DB is in one file/filegroup. Would splitting this into multiple files provide any benefit in this regard? They'd all still be...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Are the posted questions getting worse?

    Alvin Ramard (4/5/2010)


    CirquedeSQLeil (4/5/2010)


    Matt Miller (#4) (4/5/2010)


    If you need a gag gift - I think I have a full set of floppies AND manuals for Office 4.3... It only...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Working with Queues in SQL Server

    Nice Article, and better discussion.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Removing duplicates and keeping 1 record with no PK

    PaulB-TheOneAndOnly (4/5/2010)


    I've seen so many "duplicate rows" postings lately that I feel somebody has to tell people Microsoft is not charging a license fee per unique index.

    Once you have...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: very busy disk

    Paul White NZ (4/5/2010)


    CirquedeSQLeil (4/5/2010)


    Paul White NZ (4/5/2010)


    I still think it was the virus scanner :rolleyes:

    (joking!)

    Maybe Zenoss had an identity crisis and tried performing virus scans:Whistling:

    Heh...maybe 😛

    At any rate, I...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Are the posted questions getting worse?

    Matt Miller (#4) (4/5/2010)


    CirquedeSQLeil (4/5/2010)


    Nostalgic yes - But I have found that a bunch of mine were unreadable after several years in storage. I think I still have some,...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 15 posts - 15,361 through 15,375 (of 19,560 total)