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 |
|
tapaswani86
Starting Member
26 Posts |
 Posted - 2011-09-19 : 00:07:59
|
| Hi All,1)What are the performance issues we face in production server?2)How we eliminate those issues?Thanks and Regards,Tapaswani |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-19 : 00:40:37
|
| this is a very open ended question. performance can affect due to lot of reasons . Is this an interview question by the way?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
tapaswani86
Starting Member
26 Posts |
Posted - 2011-09-19 : 00:46:23
|
| Yes.... |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2011-09-19 : 09:20:31
|
| http://msdn.microsoft.com/en-us/library/ff647681.aspx |
|
|
|
Jason W
Starting Member
19 Posts |
Posted - 2011-09-19 : 13:19:54
|
| This might help you get started, in a roundabout way. The troubleshooting tool on this page helps identify performance issues and steps to resolve them. Slowness can be gradual or sudden, all procedures or 1 procedure... more or less. This tool takes you through some steps to resolve those issues and the key points to check. Certainly not all of them, you could literally write a 500 book on that. Each topic that gets highlighted at the bottom should give you a good spread of answers.http://www.sqloptimizationsschool.com/Troubleshooting/Tool.aspx |
|
|
|
tapaswani86
Starting Member
26 Posts |
Posted - 2011-09-20 : 23:36:38
|
| Thanks..... |
|
|
|
|
|
|
Performance issue