Hi

You could possibly have a look at "Proclarity" or "Panorama". These are both good tools.

I have only worked with Proclarity but have heard good things about Panorama.

Cheers

Jacques

Hi All

To check that SSIS is running you can have a look under your services and look for SSIS and if it is running I would asume that all was...

Hi All

After the dimension changes that were done the above memory errors did not occur again. The server from a SSAS point of view is running smoothly at the moment.

Thanks...

Hi All

This has been a nightmare to try and find a solution. I have found more symptoms but no solutions as yet.

The SQL server is very unresponsive when using SSIS...

I have made some dimension modifications to try and sort it our. Still reading through the Perf doc though. I read what I needed to for the memory and now...

Hi

Sorry for the delay in replying. But it took me 2 days to try and trap this.

A user ran a query that gathered information from the mtd and history sales...

This is a Windows 2003 server and I have not enables the /3GB switch but will do so. Both installations were default and no configs were done. This was done...

I am still stunned that the virtual machine running on VMware did not have any issues running with 2GB ram operating both SQL and SSAS on Windows 2003 and that...

Interesting enough during the testing phase on the virtual machine that was less than half the spec of the production machine no such issues have been found. SQL grabs around...