Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
saikiran
Starting Member
10 Posts |
 Posted - 2013-02-17 : 00:51:41
|
| Please tell me different techniques to improve perfomance of SQL SERVER 2005sai |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-02-17 : 01:12:24
|
| @saikiran - there are many techniques. It is important to differentiate between best practises , optimization and troubleshooting techniques. SQL Server does not exist in its own bubble, it resides on hardware, networks etc, so it is important as a DBA to have a very good understanding of the supporting technologies. There are all types of performance problems , such as badly writtern queries - which require a certain aproach and disk contention issues - which requires a different approach. Are you having a specific problem?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
|
|
|
HOW TO IMPROVE PERFORMANCE OF SQL SERVER IN DIFF