Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2013

    Question Unanswered: Configuring MS SQL Server system databases - best practices?


    I need some advices and best practices regarding the size of MS SQL Server system databases. We use MS SQL Server for few services for our product and we provide to the clients sizing for production databases. Now we have a request to provide sizing for MS SQL system databases. How to accomplish that, on what facts? Some recommendations are that master,msdb,model and resource could be configured by default but the size of tempdb is affecting the performance system I should be consider properly.

    Is there any documentation regarding this topic or some useful links?

    Thanks. Best Regards.

  2. #2
    Join Date
    Feb 2013
    perth australia


    Hi there,

    Only tempdb might need to be adjusted.

    Do you apps write a lot to temp tables as temporary storage.

    My suggestion is to leave as default size unless you do a trial run and get an indication of the size of tempdb ( after all the auto-increments have happened ).


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts