The sql server performance and optimization can be improved in many ways, but it again depends on the number of factors and individual scenariso, here are some the of steps taken by myself.
1. Check the size of the tables, you can use the query from my post which identifies the largest table.
2. Check the max. cpu utilization, you can use the query from my post on this. Then you can work on the sql query.
3. Check the indexes on the table, see if the tables have clustered index and non clustered index, it depends on how the table is queried and what fields are queried.
4.Location of the mdf and ldf files, it is advisable for optimimum performance to locate the temp database file on d:/ drive, mdf on the e:/ and the ldf on the f:/ and leave the operating system on the c:/.
5. Check the views on the database this may used in excess, too many views causes concern on the performance of the database and on the sql server.
No comments:
Post a Comment