Announcement

Collapse
No announcement yet.

Fine tuning sql server 2008 r2

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Fine tuning sql server 2008 r2

    Hi,

    Can someone provide info on how to fine tune database in sql server 2008 r2 ?

    thanks

  • #2
    Re: Fine tuning sql server 2008 r2

    It depends on a lot of unknown factors:
    Users
    Type and number of transactions
    Size of database
    Size of queries
    ......

    Start with query optimization: http://msdn.microsoft.com/en-us/library/ms176005.aspx
    Tom Jones
    MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
    PhD, MSc, FIAP, MIITT
    IT Trainer / Consultant
    Ossian Ltd
    Scotland

    ** Remember to give credit where credit is due and leave reputation points where appropriate **

    Comment

    Working...
    X