Analysis Services 2005 taking over resources

I’ve been doing a lot of work with SQL Server 2005 Analysis Services and have noticed that it seems to consume a lot of resources from memory to CPU.  My below is an example, but one of the small ones.  I snap that photo and then it jumped to 75% CPU and 500meg of memory when I had the SQL Business Intelligence Designer up.

Anyway to put any constraints on SSAS05 from taking over the whole machine?

Patrick

Categories: SQL

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s