August 9, 2011 at 11:32 am
Hi Friends,
In our environment we have NT server which host both SQL Server Engine and SQL Analysis Engine. While running the cube processing Analysis service fully occupies the entire CPU usage of that NT Box and doesnt allow even windows process to communicate with other external services(like domain controller to synchronize time) thus lead to outage of SQL Server Engine. I need to govern the resource usage by the services. Tried Resource Governor but it will work only for SQL Server Engine not for SQL Analysis Services. Also tried Windows System Resource Manager it is ok but not effectively managing. Is there any way to control the resource usage by SQL Analysis Services.Kindly let me know your thoughts.
Kind regards,
August 9, 2011 at 11:44 am
August 9, 2011 at 12:01 pm
You are using NT server as you say so I must ask what specific version of windows? What version and edition of SQL server as well as Analysis services are you using?
Also, can you give us hardware specifics?
When building the cubes, are stored procs the data sources for those cubes?
Index analysis - has it been done?
How about query tuning?
This is one of those cases where I would avoid the use of a VM. Cube building is usually resource intensive, and it is a process I would prefer to be on a physical host.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 9, 2011 at 12:29 pm
Hi ,
Thanks for the reply.. what is VM?
August 9, 2011 at 1:11 pm
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply