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 |
|
ovc
Starting Member
35 Posts |
 Posted - 2012-05-19 : 12:24:35
|
| I have to write a thesis regarding SQL Server performance analysis including analysis of operating system resources, sql server configuration and query tuning.It can include issues like:->high CPU usage->high memory usage->blocking, locks/deadlocks->timeouts->long running queries(or other)Any personal information will be excluded from the thesis.I have don this in the past 1,5 years for different person, mostly on production environments.Can somebody help me or needs some help with such an analysis? There is no need for getting direct access on the particular systems. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-05-19 : 12:42:24
|
| Are you looking for a practical scenario? If so, couldn't you set up a server, get some workload , and perform some performance analysis?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
ovc
Starting Member
35 Posts |
Posted - 2012-05-19 : 12:57:52
|
| Hello Jacky,I am not searching for a particular scenario on some specific issues. I am looking to analyze all kinds of problems rather to reproduce issues.I have gathered now some experience in doing this, but from legal reasons, I can not use that data from the people I have already done this.That is why, i am posting this thread. I would do this for free in exchange of being able to use the results of the analysis in the thesis. |
|
|
|
|
|
|
Performance Analysis