I will a speedy help in resolving a performance issue that my management have asked for. We need this report urgently to try to justify purchasing additional cores for our servers because they maxing out in memory and CPU.
I need to create a report (table) over a period of 1 week using the following criteria:
1) Number of Store Users, that logs onto the system throughout the day
2) Number of Sysad Users, that logs onto the system throughout the day (Sysad=administrators)
3) Maximum Number of Concurrent Store Users, that logs onto the system on one day
4) Maximum Number of Concurrent Sysad Users, that logs onto the system on one day.
Can this requirement be accomplished using the MON_GET_CONNECTION/MON_GET_CNNECTION_DETAILS views? If so, how can that be used and if possible can you show example of the kind of script to use?
Do anyone kow of script or set of scripts that can provide the information that I am looking for using the criteria above?
Please help if you can...Ineed this urgently