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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-08-26 : 03:20:15
|
| Dear Experts,please provide me some good ideas for 1)monitoring the Performance of sql server. 2)how to know that what % of ram is utilizing for which actionplease guide me in this regard and please provide me the daily, weekly and monthly check listArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-26 : 04:00:54
|
| try using Performance Monitor counters |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-08-26 : 05:29:07
|
| please provide me some detailed steps.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-08-26 : 08:46:02
|
| Using performance monitor with SQL Profiler will yield good results. SQL Profiler will give very good granular insight into variou aspects of queries , errors, locks etc . i.e data handling that is taling up memory. Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-08-27 : 01:20:25
|
| Dear jackV, really i'm sorry to say like this...i know how to use profiler, but i dont know what are the values that is returning and based on that how can i measure.....is there any standard value template for that to compare? please help meArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
how to monitor the performance