Performance issue? Anyone seeing any?

randyv

I just un-installed Monitor 2 for the time being.

I'm going through an ETL to convert our company to a new system.
The new system server was being monitored. All day I've been trying to load data into a target table using the import tool of the vendor's software and it just wasn't going it.

I noticed memory use was very high during this time and I couldn't figure out why.

I decided to just uninstall Monitor 2. I did that (which was on another server for the web and base monitor); then started the batch load again.
The server ran like a scalded dog and finished in 10 minutes!

Anyone have any idea why that would happen? Could it just be coincidence? I don't think so because the batch was the same file. I just killed the load; uninstalled Monitor 2, then restarted the load clean.

Interested in any ideas anyone may have. I'd like to use Monitor 2 as this will be the going forward product, but I can't have it tying up my production servers.

hbuckner

I have several servers being monitored and have not seen any high numbers. Did you open task manager to see what processes were consoming the memory.

randyv wrote:

I just un-installed Monitor 2 for the time being.

I'm going through an ETL to convert our company to a new system.
The new system server was being monitored. All day I've been trying to load data into a target table using the import tool of the vendor's software and it just wasn't going it.

I noticed memory use was very high during this time and I couldn't figure out why.

I decided to just uninstall Monitor 2. I did that (which was on another server for the web and base monitor); then started the batch load again.
The server ran like a scalded dog and finished in 10 minutes!

Anyone have any idea why that would happen? Could it just be coincidence? I don't think so because the batch was the same file. I just killed the load; uninstalled Monitor 2, then restarted the load clean.

Interested in any ideas anyone may have. I'd like to use Monitor 2 as this will be the going forward product, but I can't have it tying up my production servers.

dlkj

Hi Randy,

I'm sorry you've had a performance problem that might be related to SQL Monitor. If you can, please send any information that would help us reproduce or diagnose the problem to daniel.kenyon-jones {AT} red-gate.com .

Cheers,
--
Daniel