Showing posts with label client. Show all posts
Showing posts with label client. Show all posts

Thursday, March 8, 2012

Another licensing question...

Hi,
Here is a brief intro about our application.
1) The client is a Borland C++ application acting as the front
end.
2) The client sends requests to our web server (IIS) over HTTPS.
3) The web server invokes a windows service.
4) The windows service calls a COM+ component.
5) The COM+ component accesses a SQL Server 2000 EE (Cluster). We
have 4 processor licenses.
6) There are few other applications, which run on another server,
accessing the SQL server also.
7) The COM+ component forwards client requests (after some
processing) to these applications.
8) These applications send the requests to external parties,
usually over one/two (not more) TCP connections.
9) The external parties send the responses to our requests
10) The responses from the external parties are routed back to the
clients thru the COM+ component.
When the client is started on the end user's desktop, it throws up
a logon screen where the user enters his user ID and password. This is
the first request from the client to the web server. If the
authentication (the user IDs and paasswords are stored in the SQL
server) is successful, he can send more requests (order entry
application). We have about 20 users right now who access the system
this way.
The client software is available for free download, but the user
ID/password is handed over only to a very restricted set of people. We
charge certain $$ per user per month.
We are duplicating this environment in another data center.
Now my question is since we have only about 20 users accessing the
SQL server, is it enough to get 1 server license and 20 CALs? There
may be other users, who might connect but fail to authenticate, though
that is a very very rare case. Even though they are invalid users, do
they make a genuine case for going for processor licenses?
Thanks & regards
zrb
I suggest you consult a Microsoft representative about this. What you
have described *may* constitute hosting. The standard retail licence
has a "no commercial hosting" clause so you may need to purchase a
service provider licence.
I say "may" because I have no real idea what Microsoft classes as
commercial hosting. In any case an authorised rep should be able to
give you a definitive answer.
David Portas
SQL Server MVP
|||Thanks. I am thoroughly confused now. :-) I'll contact a MS rep on
this.
David Portas wrote:
> I suggest you consult a Microsoft representative about this. What you
> have described *may* constitute hosting. The standard retail licence
> has a "no commercial hosting" clause so you may need to purchase a
> service provider licence.
> I say "may" because I have no real idea what Microsoft classes as
> commercial hosting. In any case an authorised rep should be able to
> give you a definitive answer.
> --
> David Portas
> SQL Server MVP
> --
|||Also, if I have 4 processor licenses (we paid $80,000 for them), but
have 2 Dual Processor servers, does this entitle me to install SQL
server on the two servers? In the same vein, can I go for 4 single
processor servers? :-)
|||Yes. A processor licence is just that - per processor. You just need a
licence for each processor in each server.
David Portas
SQL Server MVP

Another licensing question...

Hi,
Here is a brief intro about our application.
1) The client is a Borland C++ application acting as the front
end.
2) The client sends requests to our web server (IIS) over HTTPS.
3) The web server invokes a windows service.
4) The windows service calls a COM+ component.
5) The COM+ component accesses a SQL Server 2000 EE (Cluster). We
have 4 processor licenses.
6) There are few other applications, which run on another server,
accessing the SQL server also.
7) The COM+ component forwards client requests (after some
processing) to these applications.
8) These applications send the requests to external parties,
usually over one/two (not more) TCP connections.
9) The external parties send the responses to our requests
10) The responses from the external parties are routed back to the
clients thru the COM+ component.
When the client is started on the end user's desktop, it throws up
a logon screen where the user enters his user ID and password. This is
the first request from the client to the web server. If the
authentication (the user IDs and paasswords are stored in the SQL
server) is successful, he can send more requests (order entry
application). We have about 20 users right now who access the system
this way.
The client software is available for free download, but the user
ID/password is handed over only to a very restricted set of people. We
charge certain $$ per user per month.
We are duplicating this environment in another data center.
Now my question is since we have only about 20 users accessing the
SQL server, is it enough to get 1 server license and 20 CALs? There
may be other users, who might connect but fail to authenticate, though
that is a very very rare case. Even though they are invalid users, do
they make a genuine case for going for processor licenses?
Thanks & regards
zrbI suggest you consult a Microsoft representative about this. What you
have described *may* constitute hosting. The standard retail licence
has a "no commercial hosting" clause so you may need to purchase a
service provider licence.
I say "may" because I have no real idea what Microsoft classes as
commercial hosting. In any case an authorised rep should be able to
give you a definitive answer.
--
David Portas
SQL Server MVP
--|||Thanks. I am thoroughly confused now. :-) I'll contact a MS rep on
this.
David Portas wrote:
> I suggest you consult a Microsoft representative about this. What you
> have described *may* constitute hosting. The standard retail licence
> has a "no commercial hosting" clause so you may need to purchase a
> service provider licence.
> I say "may" because I have no real idea what Microsoft classes as
> commercial hosting. In any case an authorised rep should be able to
> give you a definitive answer.
> --
> David Portas
> SQL Server MVP
> --|||Also, if I have 4 processor licenses (we paid $80,000 for them), but
have 2 Dual Processor servers, does this entitle me to install SQL
server on the two servers? In the same vein, can I go for 4 single
processor servers? :-)|||Yes. A processor licence is just that - per processor. You just need a
licence for each processor in each server.
--
David Portas
SQL Server MVP
--

Another licensing question...

Hi,
Here is a brief intro about our application.
1) The client is a Borland C++ application acting as the front
end.
2) The client sends requests to our web server (IIS) over HTTPS.
3) The web server invokes a windows service.
4) The windows service calls a COM+ component.
5) The COM+ component accesses a SQL Server 2000 EE (Cluster). We
have 4 processor licenses.
6) There are few other applications, which run on another server,
accessing the SQL server also.
7) The COM+ component forwards client requests (after some
processing) to these applications.
8) These applications send the requests to external parties,
usually over one/two (not more) TCP connections.
9) The external parties send the responses to our requests
10) The responses from the external parties are routed back to the
clients thru the COM+ component.
When the client is started on the end user's desktop, it throws up
a logon screen where the user enters his user ID and password. This is
the first request from the client to the web server. If the
authentication (the user IDs and paasswords are stored in the SQL
server) is successful, he can send more requests (order entry
application). We have about 20 users right now who access the system
this way.
The client software is available for free download, but the user
ID/password is handed over only to a very restricted set of people. We
charge certain $$ per user per month.
We are duplicating this environment in another data center.
Now my question is since we have only about 20 users accessing the
SQL server, is it enough to get 1 server license and 20 CALs? There
may be other users, who might connect but fail to authenticate, though
that is a very very rare case. Even though they are invalid users, do
they make a genuine case for going for processor licenses?
Thanks & regards
zrbI suggest you consult a Microsoft representative about this. What you
have described *may* constitute hosting. The standard retail licence
has a "no commercial hosting" clause so you may need to purchase a
service provider licence.
I say "may" because I have no real idea what Microsoft classes as
commercial hosting. In any case an authorised rep should be able to
give you a definitive answer.
David Portas
SQL Server MVP
--|||Thanks. I am thoroughly confused now. :-) I'll contact a MS rep on
this.
David Portas wrote:
> I suggest you consult a Microsoft representative about this. What you
> have described *may* constitute hosting. The standard retail licence
> has a "no commercial hosting" clause so you may need to purchase a
> service provider licence.
> I say "may" because I have no real idea what Microsoft classes as
> commercial hosting. In any case an authorised rep should be able to
> give you a definitive answer.
> --
> David Portas
> SQL Server MVP
> --|||Also, if I have 4 processor licenses (we paid $80,000 for them), but
have 2 Dual Processor servers, does this entitle me to install SQL
server on the two servers? In the same vein, can I go for 4 single
processor servers? :-)|||Yes. A processor licence is just that - per processor. You just need a
licence for each processor in each server.
David Portas
SQL Server MVP
--

Saturday, February 25, 2012

Anonymous Access from Pivot Table to OLAP 2005

My asp-net web application connect to Analysis Services 2005 through Pivot Table client.

To use anonymous access with AS2000 i used to add this property to the connection string of the pivot: "SSPI=anonymous".

Which property give me the same thing with AS2005?

Thanks!

Hi,

The SSPI connection property is still there, so it should work the same. Are you getting an error?

David Botzenhart

|||

Hey David - good to hear from you !

Yes, you could still use SSPI=anonymous, but I really recommend in AS2005 to use standard OLEDB property for this purpose, i.e.

Protection Level=none

It has slightly better (more standard) behavior.

Mosha (http://www.mosha.com/msolap )

|||

Thanks, it's working.

But, if i set "Impersonation Level" property to Anonymous? Is this the same of SSPI=anonymous?

Announcing SQL Server Everywhere Edition

Today we are announcing SQL Server Everywhere Edition, a light weight database designed for client applications that run from desktops to mobile devices. Pl see the section 'Dynamic Applications' in the Microsoft's Data Platform Vision and Roadmap from Paul Flessner, Sr VP, Microsoft.

Microsoft’s Data Platform Vision and Roadmap: Your Data, Any Place, Any TimeMicrosoft’s Data Platform Vision and Roadmap: Your Data, Any Place, Any Time

http://www.microsoft.com/sql/letter.mspx

The new product is based on the familiar SQL Server Mobile Edition.

-Durga Gudipati

Program Manager, SQL Server Everywhere Edition

We are in the very begining of migration to 3rd party solution for storing user documents. We currently use SQLCE2.0 and we were terribly disapointed that MS decided not to license its interoperability of SQLCE3.0 databases across all platforms.

I need to know the licensing policy of the new product before May 16th. Is it going to be royalty-based or similar to SQL Mobile (i.e. virtually free)?

|||

Can you please provide more information than this letter

|||

some more info but not much

http://blogs.msdn.com/search/SearchResults.aspx?q=SQL+Server+Everywhere+Edition&o=Relevance

|||

SQL Everywhere (SQL Ev) will be free on desktops, laptops/tablets and mobile devices running MS OS.

The first CTP will be in summer and release will be by end of the year.

Once released, SQL Everywhere replaces SQL Mobile.

-DurgaG

Friday, February 24, 2012

Annon Merge over VPN: WSM Insanity

I have my replication "working", though I would like to script as much
of the client installation as possible, and running into mega
headaches.
Here's the setup:
Client - MSDE
connects to Publisher/Distributor via VPN
annonymous pull subscription
I can install my MSDE, create the db, logins, etc.
1) Through EM, I can create the subscription through wizard. (selecting
"Available to Synch Manager", "Start immediately"). It works.
Syncronization Manager (type in passwords) synch works.
2) I script the subscription created in 1). Delete subscription and run
script with osql (doesn't run Merge Agent job automatically. Why not? I
even put in an extra line: EXEC sp_start_job @.job_name =
'MERGE_AGENT_JOBNAME'). Go back to EM, right click on subsrciption -
Start Synchronizing. It works. WSM (type in passwords) synch works.
3). Delete subcription and recreate with same script as above. Go
straight to WSM. The subscription is in the list. Synch (type in
passwords). DOES NOT WORK!!! I get the error "the schema script <blah
blah blah> could not be propagated to the subscriber."
Why should I have to run the subscription once through EM before it
will work with WSM? I guess it has something to do with that Merge
Agent job and it needs to be fired off first?
Obviously EM will not be distributed to my end users in far off lands.
I want them to be able to run a script and then synch through WSM. What
is the best way to achieve this?
Much Thanks
answers in line.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<richerwin@.ubs-europe.org> wrote in message
news:1109180376.620053.87490@.o13g2000cwo.googlegro ups.com...
> I have my replication "working", though I would like to script as much
> of the client installation as possible, and running into mega
> headaches.
> Here's the setup:
> Client - MSDE
> connects to Publisher/Distributor via VPN
> annonymous pull subscription
> I can install my MSDE, create the db, logins, etc.
> 1) Through EM, I can create the subscription through wizard. (selecting
> "Available to Synch Manager", "Start immediately"). It works.
> Syncronization Manager (type in passwords) synch works.
I take it you are using SQL Authentication in WSM. If so your user will have
to enter the password each time WSM runs. You might want to use intergrated
authentication and enter the user account in the pal on the publisher.

> 2) I script the subscription created in 1). Delete subscription and run
> script with osql (doesn't run Merge Agent job automatically. Why not? I
> even put in an extra line: EXEC sp_start_job @.job_name =
> 'MERGE_AGENT_JOBNAME'). Go back to EM, right click on subsrciption -
> Start Synchronizing. It works. WSM (type in passwords) synch works.
The merge agent doesn't start automatically because you have defined it to
start on demand.

> 3). Delete subcription and recreate with same script as above. Go
> straight to WSM. The subscription is in the list. Synch (type in
> passwords). DOES NOT WORK!!! I get the error "the schema script <blah
> blah blah> could not be propagated to the subscriber."
This means that the subscriber does not have rights to read the snapshot
share. You will have to craft a new snapshot share which does not use the
administrative share (ie \\servername\c$\Program Files\Microsoft SQL
Server\MSSQL\ReplData\UNC). Make sure this new snapshot share has read
permission for the accounts or a group which the merge users are in, and
that this group or user has rights to read the underlying files and folders.
> Why should I have to run the subscription once through EM before it
> will work with WSM? I guess it has something to do with that Merge
> Agent job and it needs to be fired off first?
This does sound odd. Perhaps it is a rights issue.
> Obviously EM will not be distributed to my end users in far off lands.
> I want them to be able to run a script and then synch through WSM. What
> is the best way to achieve this?
> Much Thanks
>
|||
> This does sound odd. Perhaps it is a rights issue.
I create my subscription. Local machine is RICH-VAIO,
Publisher/Distributor is WSCLAN08; database is TMS. At both ends, the
SQL Server is the default instance.
1) I run the following Win2000 DOS BATCH command:
"C:\Program Files\Microsoft SQL Server\80\COM\replmerg.exe" -Publisher
[WSCLAN08] -PublisherDB [TMS] -Publication [pubUser100] -PublisherLogin
[tmsuser] -PublisherPassword [tmsuser] -Distributor [WSCLAN08]
-DistributorLogin [tmsuser] -DistributorPassword [tmsuser] -Subscriber
[RICH-VAIO] -SubscriberDB [TMS] -SubscriptionType 2
-SubscriberSecurityMode 0 -SubscriberLogin [tmsuser]
-SubscriberPassword []
and get the following log:
Microsoft SQL Server Merge Agent 8.00.760
Copyright (c) 2000 Microsoft Corporation
Connecting to Subscriber 'RICH-VAIO'
Connecting to Distributor 'WSCLAN08'
Initializing
Connecting to Publisher 'WSCLAN08'
Retrieving publication information
Retrieving subscription information
The subscription has been marked for reinitialization. Reinitialization
will occur the next time you synchronize this subscription.
The schema script
'\\WSCLAN08\ReplData\unc\WSCLAN08_TMS_pubUser100\2 0050224042747\snapshot.pre'
could not be propagated to the subscriber.
Category:NULL
Source: Merge Replication Provider
Number: -2147201001
Message: The schema script
'\\WSCLAN08\ReplData\unc\WSCLAN08_TMS_pubUser100\2 0050224042747\snapshot.pre'
could not be propagated to the subscriber.
Category:AGENT
Source: RICH-VAIO
Number: 0
Message: The process could not read file
'\\WSCLAN08\ReplData\unc\WSCLAN08_TMS_pubUser100\2 0050224042747\snapshot.pre'
due to OS error 1326.
Category:OS
Source:
Number: 1326
Message: Logon failure: unknown user name or bad password.
2) Immediately, I go to EM, right click on my subscription, and select
Start Synchronizing. The last entry in the log history is:
The job succeeded. The Job was invoked by User tmsuser. The last step
to run was step 1 (Run agent.).
3) Immediately, I run the same batch file as above. I get the following
log:
Microsoft SQL Server Merge Agent 8.00.760
Copyright (c) 2000 Microsoft Corporation
Connecting to Subscriber 'RICH-VAIO'
Connecting to Distributor 'WSCLAN08'
Initializing
Connecting to Publisher 'WSCLAN08'
Retrieving publication information
Retrieving subscription information
The merge process is cleaning up meta data in database 'TMS'.
The merge process cleaned up 0 row(s) in MSmerge_genhistory, 0 row(s)
in MSmerge_contents, and 0 row(s) in MSmerge_tombstone.
The merge process is cleaning up meta data in database 'TMS'.
The merge process cleaned up 0 row(s) in MSmerge_genhistory, 0 row(s)
in MSmerge_contents, and 0 row(s) in MSmerge_tombstone.
Uploading data changes to the Publisher
No data needed to be merged.
Downloading data changes to the Subscriber
4) Successive changes to the data at the subscriber are successfully
uploaded as in 3).
WHAT THE FREAK IS GOING ON WITH Merge Agent?
Please, please, please help. My kindom for a solution.
It must be noted I am not logged into Win2000 as tmsuser, though
tmsuser is a domain user under which SQLSERVER AGENT runs at the
subscriber, and tmsuser has full rights on the snapshot share at the
Publisher (as evident by the successful replications above).
|||just a wild thought here - why are you running the merge binary from the
command line?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<richerwin@.ubs-europe.org> wrote in message
news:1109221256.951320.175930@.f14g2000cwb.googlegr oups.com...
>
> I create my subscription. Local machine is RICH-VAIO,
> Publisher/Distributor is WSCLAN08; database is TMS. At both ends, the
> SQL Server is the default instance.
>
> 1) I run the following Win2000 DOS BATCH command:
> "C:\Program Files\Microsoft SQL Server\80\COM\replmerg.exe" -Publisher
> [WSCLAN08] -PublisherDB [TMS] -Publication [pubUser100] -PublisherLogin
> [tmsuser] -PublisherPassword [tmsuser] -Distributor [WSCLAN08]
> -DistributorLogin [tmsuser] -DistributorPassword [tmsuser] -Subscriber
> [RICH-VAIO] -SubscriberDB [TMS] -SubscriptionType 2
> -SubscriberSecurityMode 0 -SubscriberLogin [tmsuser]
> -SubscriberPassword []
> and get the following log:
> Microsoft SQL Server Merge Agent 8.00.760
> Copyright (c) 2000 Microsoft Corporation
> Connecting to Subscriber 'RICH-VAIO'
> Connecting to Distributor 'WSCLAN08'
> Initializing
> Connecting to Publisher 'WSCLAN08'
> Retrieving publication information
> Retrieving subscription information
> The subscription has been marked for reinitialization. Reinitialization
> will occur the next time you synchronize this subscription.
> The schema script
>
'\\WSCLAN08\ReplData\unc\WSCLAN08_TMS_pubUser100\2 0050224042747\snapshot.pre
'
> could not be propagated to the subscriber.
> Category:NULL
> Source: Merge Replication Provider
> Number: -2147201001
> Message: The schema script
>
'\\WSCLAN08\ReplData\unc\WSCLAN08_TMS_pubUser100\2 0050224042747\snapshot.pre
'
> could not be propagated to the subscriber.
> Category:AGENT
> Source: RICH-VAIO
> Number: 0
> Message: The process could not read file
>
'\\WSCLAN08\ReplData\unc\WSCLAN08_TMS_pubUser100\2 0050224042747\snapshot.pre
'
> due to OS error 1326.
> Category:OS
> Source:
> Number: 1326
> Message: Logon failure: unknown user name or bad password.
> 2) Immediately, I go to EM, right click on my subscription, and select
> Start Synchronizing. The last entry in the log history is:
> The job succeeded. The Job was invoked by User tmsuser. The last step
> to run was step 1 (Run agent.).
> 3) Immediately, I run the same batch file as above. I get the following
> log:
> Microsoft SQL Server Merge Agent 8.00.760
> Copyright (c) 2000 Microsoft Corporation
> Connecting to Subscriber 'RICH-VAIO'
> Connecting to Distributor 'WSCLAN08'
> Initializing
> Connecting to Publisher 'WSCLAN08'
> Retrieving publication information
> Retrieving subscription information
> The merge process is cleaning up meta data in database 'TMS'.
> The merge process cleaned up 0 row(s) in MSmerge_genhistory, 0 row(s)
> in MSmerge_contents, and 0 row(s) in MSmerge_tombstone.
> The merge process is cleaning up meta data in database 'TMS'.
> The merge process cleaned up 0 row(s) in MSmerge_genhistory, 0 row(s)
> in MSmerge_contents, and 0 row(s) in MSmerge_tombstone.
> Uploading data changes to the Publisher
> No data needed to be merged.
> Downloading data changes to the Subscriber
> 4) Successive changes to the data at the subscriber are successfully
> uploaded as in 3).
>
> WHAT THE FREAK IS GOING ON WITH Merge Agent?
> Please, please, please help. My kindom for a solution.
> It must be noted I am not logged into Win2000 as tmsuser, though
> tmsuser is a domain user under which SQLSERVER AGENT runs at the
> subscriber, and tmsuser has full rights on the snapshot share at the
> Publisher (as evident by the successful replications above).
>
|||
> why are you running the merge binary from the command line?
1) To show I'm getting the same results as from WSM.
2) So I can write the results to a log file with the >> redirect
command (so I can post them here) and show the group what I am doing.
3) End users won't have EM, so they need a way to start replication
(which isn't working from WSM, which is why I started this thread)
4) Proof of concept - it SHOULD work, shouldn't it?
thanks
|||[vbcol=seagreen]
This must have to do with accounts / permissions.
I have a couple of theories.
1) Why would executing the Merge agent job from within EM work, while
neither command-line nor WSM work? After all, I generated the
command-line args from the job from EM.
Is EM firing off the merge job under the same userID that I am when I
fire off the command line? (In the example above, both should be
'tmsuser'). How can I tell?
2) When I execute synchronize from WSM, do I have to be logged in to
Windows with the same domain ID that SQLSERVER AGENT (Windows service)
runs under?
Any help appreciated.
Thanks

Monday, February 13, 2012

Analysis Services on the web problems

Hi,

I basically have 2 problems:

1]I am on a client Machine (Win2000 client).This is within the firewall. My SQL Server2000(Mixed mode authentication,Enterprise Edition) and Analysis server are on a Windows 2000 Advnaced Server running with IIS 5.0.This server is outside the firewall. I also have Analysis services installed on machine. I wanted to create a cube on my client machine using the SQL Server 2000 on the machine outsided the firewall.So I did the following.
[a]Created a system DSN , say TRIALDSN, on my client that points to the SQL server,with 'sa' and password as 'admin'.It worked.
[b]Then I went to Analysis services on my client, created a new
Database, and a new Data Source with the DSN name as TRIALDSN.This worked too.And THEN, I right clicked on the Cube directory and said New Cube|Editor. I am getting the message .."Connection to the 'servername-databasename' data source failed.Error:Login failed for user 'sa'.Do you want to retry? with 'Yes' and 'No' options. Can anyone help me with this error....
2]With the same setup as above, I am trying to view the cubes on the server from my client PC. I am stuck with a problem here too. This is what is my requirement.
I need a html/asp page on the server with the cube data,that a user can access from a client machine on the internet and perform drill-downs and anything else he wants. So, this is what I tried out.
On the server outside the firewall: Got the cubes onto Excel.Here I selected the Analysis Server radio button, giving the Analysis server name as the servname(that is the name of the same machine),say "ABC01". I did (and tried without too) give the username and password for the http connections.Got the data onto excel.Then I did a 'Save As Web Page' and got the excel as an html, with all the excel features still retained (although the 3D effects of the charts were lost). I then copied this html file, say, EXAMPLE.htm to the C:\inetpub\wwroot along with the msolap.asp file.
I opened the browser and gave the url for this html and everything was fine.
By the way the IIS settings are as follows:
Integrated Windows Authentication checked
Changed the default IUSR_machinename to Administrator

On the client within the firewall:Opened the browser and typed in the url as follows:
http://IP address of the server/EXAMPLE.htm
I am getting the error "The Pivot Table List 'PivotTable2' could not connect to the data source "cubename".For information about the data source, consult the creator of the file.
0x80040e4d: The operation requested failed due to security problems - the user could not be authenticated.
Some how, the data source property with the value 'ABC01' in the connection string of the html is giving the problem. What should I do?? But the whole point is, I am able to access normal html pages on the server from the client, that is , html pages that do not connect to cubes.
I am desparate for help. Thanks in advance.

AshCould you find the solution. If yes, pls. pls. let me know.

I am having the same error and I need some quick solution. My email: surbha0@.yahoo.com

Thanks a lot in advance,
Saurabh

Thursday, February 9, 2012

Analysis Services 2005 using only one CPU

Hi,

I am facing issue with our client related to Analysis Services 2005 using only 13% of CPU.

Our client is running on server with 8 CPUs, 15GB of RAM. When request being made to execute MDX, only 13% of CPU is utilized. It is like using only one CPU. When additional concurrent user is added, then CPU usage increases.

The Analaysis Services being used is Evaluation Copy at this point.

I checked all possible settings in Analysis Services, like to increase concurrent threads, and other settings, but it brings no result. CPU is stuck at 13% for single user.

So, is it like limitation of SQL Server Evaluation copy that it does not utilize full CPU, or Analysis Services is not meant to use more that 1 CPU (which is unlikely)?

Can you help me to troubleshoot this issue.

Thank you

Analysis Services OLAP engine is roughly divided into two major components: 1) query processor and calculation engine 2) storage engine. Storage engine is multithreaded to support parallel access to multiple partitions. The calculation engine is mainly singlethreaded. If your query is calculation intensive instead of data intensive, you would only see a single CPU maxed out.|||

thanks for clarifying the internals of Analysis Services.

At the moment i have only one partition in the OLAP Database. The performance drop when several crossjoin statements used in the MDX. I will try to optimize my mdx statements, but is there anyway to optimize calculation engine?

Will it help calculation engine if i divide my cube into several partitions? Our client data is pretty big, 1GB for 8 days data. Eventually, our client wants to keep 60 days data in the cube, and historical data being purged or archived. My intention was also eventually create partitions either monthly, or weekly as it is implemented in Project REAL.

So, what are the way you can suggest to optimize calculating engine?

Thank you.

Analysis Services 2000 with SQL Server 2005

We have an application that uses Analysis Services 2000 Cubes with SQL Server 2005. We have a new client who has SQL Server 2005 on their server. Since our application requires Analysis Services 2000, I would like to know if there is any way they can get Analysis Services 2000 without buying SQL server 2000.

Hello! AS2000 and SQL Server 2000 are bundled. You run AS2000 on your SQL Server 2000 licence.

Answere: No!

HTH

Thomas Ivarsson

|||

Thank you, that helps. I was thinking that maybe they have some components for Analysis Services 2000 like they have for DTS 2000 in SQL Server 2005. The client was complaining about having to buy both SQL Server 2005 and SQL Server 2000. I will tell them that they have to do that.

Thanks,

M.Kundeti