5.1.0.2781 ... memory consumption is HUGE?
randyv
Posts: 166
Hello -
We are seeing unusual CPU utilization curves on our 8-way server.
All CPUs are showing between 17 and 60%.
While it is not the only thing we are seeing that could be contributing to
the unusual performance spikes, I'm wondering about SQL Backup.
We looked at memory usage of processes using taskmgr.
and we found the biggest memory consumer right now is a process called
EAISQL2.exe - right now it is just over 1GB, but there are no jobs running at the moment. I suspect this is associated with SQL Backup because when I set it up, I created a user with the whimsical name 'SQLBackup'.
That is the user associated with this process.
First question - Is this normal?
Second question - anyone else report this?
I have the system configured to use AWE, and I'd say about 90% of
the available 16Gb of memory is allocated to SQL Server. I left 10% for the O/S. I'd look at the report and give you the exact stats but the system is so bottlenecked at the moment that it won't let me look at
reports.
We are seeing unusual CPU utilization curves on our 8-way server.
All CPUs are showing between 17 and 60%.
While it is not the only thing we are seeing that could be contributing to
the unusual performance spikes, I'm wondering about SQL Backup.
We looked at memory usage of processes using taskmgr.
and we found the biggest memory consumer right now is a process called
EAISQL2.exe - right now it is just over 1GB, but there are no jobs running at the moment. I suspect this is associated with SQL Backup because when I set it up, I created a user with the whimsical name 'SQLBackup'.
That is the user associated with this process.
First question - Is this normal?
Second question - anyone else report this?
I have the system configured to use AWE, and I'd say about 90% of
the available 16Gb of memory is allocated to SQL Server. I left 10% for the O/S. I'd look at the report and give you the exact stats but the system is so bottlenecked at the moment that it won't let me look at
reports.
What we do in life echoes in eternity <><
Randy Volters
Randy Volters
Comments
I don't think EAISQL2.exe has anything to do with us. I cannot seem to find exactly what is is.. I will ask around and see if anyone knows.
James
Head of DBA Tools
Red Gate Software Ltd
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8