December 27, 2014 at 9:23 pm
I'm not sure how to create a graph that collects the following information?
I would like for you to take each current server being utilized, outline the specs and resources associated and build a monitored time study to determine how it performs over a several day period based on its role.
(For example, the cyp_report server has 4 processors, 16 GB Ram, etc. Over a period of XX, the max processor utilized was XX, the sustained usage was XX, there were multiple cache reads that exceeded XXX indicating I/O was the bottleneck, etc. The peak memory usage was driven or caused by XXX. By doing XXXXX, we can reduce the memory spikes by xx%.)
Does anyone have experience with ignite?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 28, 2014 at 11:53 am
You've never used Performance Monitor before?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 28, 2014 at 4:22 pm
Yeah after looking at it is basically the same thing.
Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply