Post reply

Server Report and Recommendations

  • July 3, 2002 at 1:26 am

    #78636

    Hi All

    My mind has hit a brick wall and I need a leg up.

    I have to write a report on the current configuration of SQL Server and provide recommendations for upgrades and/or tuning .

    What I'm getting stuck on is an overall outline for the document . I can get all the required info, just can't seem to organise it in a ordered manner.

    Hope someone could give me a guiding hand, or even some template or something I could follow .

    Thanks

    Phill

    --------------------
    Colt 45 - the original point and click interface

  • July 3, 2002 at 10:15 am

    #432064

    Introduction: State what this is (current config, perform analysis and recommendations)

    Current Config: Do hardware and software. SQL config, database physical layout. Server settings, backup plan, etc.

    PErformance: Run some numbers, profiler, perf mon, etc. and determine what the server is doing. Correlate this with performance as perceived by users.

    Recommendations: Make some deicsions about what you can do to improve performance.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply