Do we have any benchmark values for the following counters... SQLServer Locks: Lock Timeouts SQLServer Access Manager: Full Scans System: Processor Queue Length SQLServer Databases: Log Growths Memory: Page Faults Target server memory Total Server memory Thanks, Ram "It is easy to write code for a spec and walk in water, provided, both are freezed..."
There are none like that but you can workout by setting a baseline at your end with a monitoring during busy hours & normal hours. http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=14511 fyi. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
If my Total Server memory and target server memory values are same, does that mean a memory bottleneck??? I have values likes... counter avg min max value ------------------------------------------------- Target Server Memory164116391642 Total Server Memory164116391642 does this mean that i have a memory bottleneck? Thanks, Ram "It is easy to write code for a spec and walk in water, provided, both are freezed..."
No,http://www.sql-server-performance.com/performance_monitor_counters_memory.asp fyi. If you are having any performance issues currently then assess them and explain the situation. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
no performance issues.,in one of the articles in SSP, i read that...<br /><br />[if the SQLServer:Memory Manager: Total Server Memory (KB) counter is more or equal than the SQLServer:Memory Manager: Target Server Memory (KB) counter, this indicates that SQL Server may be under memory pressure and could use access to more physical memory.] <br /><br />And, my DBA said that never in a perfmon, the Tot SM would be shown greater that target SM. and, if it equal then it blindly means it needs more memory.<br /><br />I was hoping to get a proof to shut his mouth [<img src='/community/emoticons/emotion-2.gif' alt='' />]<br /><br />Thanks,<br />Ram<br /><br />"It is easy to write code for a spec and walk in water, provided, both are freezed..."
Check what kind of other applications are on SQL server that are hungry for Memory. I would agree it is not a problem if there is difference in the performance over a period of time. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
The machine is dedicated for SQL Server. the total memory is 2 GB Thanks, Ram "It is easy to write code for a spec and walk in water, provided, both are freezed..."
