Analysis Service is slowing down the server

Hi,

I am facing the following problem on SQL2K.

When I start the service the server slows down and users start complaining that generation of reports based on system (i.e. databases) that are hosted on the same server have REALLY slowed down... and thus I have to stop the service...

Can some please guide me regarding how to solve this problem and how I can be able to use the Analysis service.

Many thanks in advance for you kind help.Howdy

It would make sense to :

(1) Ensure the tables Analysis Services are querying have good indexes on them - use profiler & Index Tuner wizrd to check

(2) RUn the queries after hours to reduce competion on resources

(3) Check perfmon and see if the box is under powered for what you are trying to do

(4) Maybe find another server and copy the database to it & run analysis services on that - that way no-one will ever complain and it may be quicker for oyu.

Cheers,

SG.

Analysis

SQL 2K
I created my cube, process data and played with it.
My question is , how to make this accessible to my users' will they have to
get into Analysis Manager '
Is there any automated job to refresh (process) my cube on a daily basis. '
Thanks
ShThere are lots of ways to make this accessible to users. You can start off
by using pivot tables in Excel (preferably Xp) this can make an olap
connection and for the most part drill down, slice, etc.
An automated way to reprocess the cube is through DTS, there is a task
called process cube. You can schedule that at your leisure.
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Shamim" <shamim.abdul@.railamerica.com> wrote in message
news:ehZx6EoYDHA.2548@.TK2MSFTNGP09.phx.gbl...
> SQL 2K
> I created my cube, process data and played with it.
> My question is , how to make this accessible to my users' will they have
to
> get into Analysis Manager '
> Is there any automated job to refresh (process) my cube on a daily basis.
'
> Thanks
> Sh
>

An attempt to attach an auto-named database for file

I build a WebApp which i use the default DataBase that come with the App_Data folder.

I have Users and roles into that folder with all my tables regarding my new App.

Why i cant make it work under IIS on my webserver ? When i open it with Visual Studio everything works but outside of it nothing.

An attempt to attach an auto-named database for file c:\inetpub\wwwroot\Survey\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf;

I look arround and cant find a thing on how to fix my issue. I try deleting the Folder under my User Account for SQL Express and nothing happend.

Make sure your IIS account (ASPNET or NETWORK SERVICE) has read&write permission on the folder where the database file locates.|||Yes i did that ! even uers have modify to it. under that folder !|||

Im still looking for help arround here !

anybody fix the issue?

|||

It is not working because IIS is not the place to store database files, you store those in the data subfolder of Microsoft SQL Server in programs. You can modify the code in the thread below for your use. You may need to start with the trail version of SQL Server and later buy the developer edition it is under $40 on the web. Hope this helps.

http://forums.asp.net/thread/977493.aspx

AMO: No mapping between account names and security IDs was done for local users

Hi,

Analysis Services 2005 and SQL Server 2005

Using AMO I'm trying to add a local user to an Analysis Services database Role that I created but I keep getting the error "No mapping between account names and security IDs was done". I can add the user to the Role with no problem using SQL Server Management studio, but if I try to add the user using AMO I get that error.

The local user that I'm trying to add belongs to both the local User and Administrator groups. I've added a logon for this local user to the corresponding SQL Server database that the Analysis Services database datasource points to, but still no luck.

Am I missing something? I've been doing this for the last three months with network users without a problem so this is completely frustrating me. Especially the fact that I can add them using the SQL Server Management Studio GUI.

Here's the basic code that I'm doing. Pretty straightforward.

private bool AddUserToAnalysisServicesRole(Role role)

{

string user = @."pdxvincentm02\testuser";

RoleMember rm = new RoleMember(user);

role.Members.Add(new RoleMember(user)); // e.g. redmond\johndoe

role.Update(); // << KABOOM!!! No mapping between ......

Help. Thanks

I have not had a chance to try this in C# yet, but I did a quick test in powershell using the following pattern and it worked.

role.Members.add("pdxvincentm02\testuser")

role.Update()

It's possible that the role.Members.Add() function has another overload that works a bit differently. But another though also occurred to me. Where is this code being executed from? Is it possibly running under an account that does not have permission to verify the account? (eg. is it running from an ASP.NET app running as local system?)