Performance monitor and performance counters
I'm trying to figure out why performance counters won't work on my machine. We've got 2 windows 2003 servers, and if I try to access ANY of the performance counter related objects in the System.Diagnostic namespace I get this:
Insufficient memory to continue the execution of the program.
at System.Runtime.InteropServices.Marshal.AllocHGlobal(IntPtr cb)
at System.Diagnostics.PerformanceMonitor.GetData(String item)
Of course the call stack is actually larger than that, but the point is right here. The same code works fine on any of our XP or 2000 Pro boxes. Anyone know wha...Performance Monitor vs performance
does Sybase Central Performance Monitor affect performance? We've had a
problem, the db server was reacting very slow denying almost all of the work
of around 100 concurrent users, with throwing all of them out as more users
came in. The only major change done was that
the Sybase Performance monitor was left to be run overnight, with the
I understand that SC PM queries the server, but could this have a major
impact on overall performance?
IMO the ...Establishing a performance baseline re performance Monitors
OK I'm new to this.
But I am administering a newly created network of <100 systems
using ASA 7.0.2
I would like to set up some monitors to know what the "typical load"
during a week is.
Which monitors are the most important?
Should I use the monitors in the W2K instead?
Posted via http://dbforums.com
...Performance Monitor Snap-in
I am trying to monitor our ASP.NET web application, running on Windows Server 2003 & IIS 6.
When I open the Performance Snap-In, I am unable to select the standard Performance objects I see in Windows 2000 server - namely ASP.NET, ASP.NET Applications, ASP.NET Apps v1.1.4322 and ASP.NET v1.1.4322
Can somebody tell me what's happening? Am I missing something?
Thanks...Documentation on performance monitoring and tuning
In a future release of ASA, it would be nice to have a much more indepth
discussion about performance tuning. As the ASA product has become more
sophisticated, the need to be able to tune the db has become much greater.
More discussion is needed in areas of what are "norms" and things that can
be done to help improve overall performance.
More ways to contact me: http://wwp.icq.com/3772174
It seems to me that the increased sophistic...ASE 15 Performance and Tuning Guides
Does anyone know when the updated ASE 15 versions of
"Performance and Tuning Guides" will be released?
The guides on sybooks are for ASE12.5.1
Thanks in advance.
> Does anyone know when the updated ASE 15 versions of
> "Performance and Tuning Guides" will be released?
I *think* that they were supposed to be released sometime
later this year, but I don't have any clear information.
I'm not aware of when these will be released. I'm guessing some time after the
What tools are availble with ASA 7 (WinNT) for performance monitoring. We
have a system that is getting pegged to 100% CPU utilization, and we're
guessing right now it's an adhoc query. Is there a way to see who is
doing what on the system at any given time?
ASA 8 has a feature which allows you to do this; in ASA 7 it's a bit more
In ASA 8, you must first enable capturing of the last statement prepared by
each connection by specifying the -zl server command line option or by
call sa_server_option('Remember_last_statement','ON...performance monitoring
We have moved our database from a slower machine to a faster dual PIII-1Ghz
machine and are trying to do some performance tuning.
The application is being accessed via Citrix Metaframe XP 1.0 SP1. There
are a few times per day when the application seems to really slow down. What
we'd like to do is monitor the backend to see if it is a problem with one of
our stored procedures or triggers or to see if there is a long running
process which could be affecting this. We've already been able to take
Citrix out of the mix as it is performaning as it should. Does anyone have
any r...Performance tuning
Is there a way to create and analyze some kind of trace files with SQL
I have a program that issues "generated" SQL statements. I'd like to
quickly look for those that create full table scans in any of the used
tables to see if I can optimize data access.
Hilden, near Duesseldorf
I wrote something like this a couple months back. It interrogates the
trace file that PowerBuilder produces. It's rather proprietary since
it's one of the tools that I use when I do Performance & Tuning
I need an off the shelf simply product that allows me to do basic performance monitoring of my website and database. I realize I can setup up performance counters but I would like a simple product that will do that for me. I am especially interested in SQL Server / ADO.NET monitoring -- memory use, number of connections open, etc.
I am looking for the same thing, so I am going to attach myself to this thread. Thanks.Don't forget to click "Mark as Answer" on the post that helped you.This credits that member, earns you a point an...ASE performance
Hi there, ask a rather beginner question here.
we have this ASE12.0 on Solaris 7. it's a enterprise 3000
machine, with 1G RAM, 2 CPUs both 168MHz. via /etc/system
assigned 800M to ASE. All other settings in the configure
file are mostly DEFAULT.
we donot have many concurrent users on system most of the
time, and the workload/ transaction is not very high. (most
time, just 50 to 60 users online).
however, lately users complains performance problem. esp
just only one user was running a little big large report.
and when I check sp_lock, actually very few locks, and just
some shared...Performance Monitor Again
We have a C++ application that uses Sybase SQL Anywhere 5.0 as the back end.
We have enabled performance monitor so that we can analyze some of options
available to us for SQL Anywhere 5.0. There are many options like active
requests, bytes receive etc. What we are trying to gain from this analysis
is confirmation that the database server is sufficient and that we are not
overloading/overworking the database server. Can someone please advise me
as to some useful measurements, as well as a normal/abnormal range for those
measurements? We have 65 workstations all mak...Performance Tools
I am having difficulty that after I complete a project and run the performance tool, by looking at the report, I do not know whether it's performing well, as there is no benchmark for me to refer to.
Is there any guide that how to consider the performance is not up to the satisfactory level? Or is there any benchmark that how many bytes of allocated memory is considered unacceptable that we need to look into?
I run select * statement from a view on both ASE11.5 and ASE12. The speeds
for returning the value are very different. On ASE11.5, it only takes 1min
while on ASE12, it takes 30min.
ASE12 has bigger data caches for the database and tempdb than what the
ASE11.5 has. Both of them have the same indexes. After I run sp_sysmon on
ASE12, in the report of data cache management, ASE12 has high cache hit
ratio (that is good) and high pool turnover (no good). Does that mean I
need to increase the data cache for ASE12? I also noticed that in OS, ASE12
has very tight free mem...