We upgraded a 2x processor server to 4x processors and our cube processing times INCREASED by about 350%. After re-optimizing several queries, I was only able to reduce the time...

Sorry, but that doesn't work! If I enter my username as a keyword, and search the forums, I only find 1 post. Apparently the search only looks thru the mail...

1) Set up an Exchange account for your SQL mail to use

2) Install Outlook on your SQL server

3) Set up a mail profile for your SQL Mail account (Control...

"Overall, their products do improve and it does take $$ for the worker bees to fix them."

http://money.cnn.com/2002/04/12/pf/agenda_msft/

It's a shame that a company with $40 billion in cash doesn't spend more...

Are you SQL2k or SQL7? I had this problem after a service pack upgrade with SQL 7. Clients with the previous service pack could not open or run packages...

By default, the metadata is stored in an access database under your Analysis Services\bin subdirectory called msmdrep.mdb. You can migrate the repository to SQL Server if you wish, by right...

Not sure about any AD issues, we're still running Win NT 4.0. Are you running the services with a service account that has admin rights on the server? Something else...

I had a similar issue with timeout errors after a SQL7 to SQL2k upgrade. I resorted to uninstalling SQL2k and reinstalling everything from scratch (rather than having an upgraded installation)....

You all make it sound all so warm and fuzzy! How about reviving the memories of all the horribly cryptic Microsoft bugs encountered over the years? }:) The pagers at...

This must have been something to do with the upgrade process somehow. I shrunk the tempdbs back to 5GB and reran our processing on both test servers. No TEMPDB increases...

The transaction logs are defined as 100mb and did not auto-grow. Perhaps this is due to the different hardware configurations between the servers? The production server is a 4x P3-500Mhz...

Set up a DTS task with an OLAP Services Processing task then schedule the job to run the DTS task. I believe the OLAP Services Processing task is an add-in...

I'd be interested to know how MS handles AS installed on a multiprocessor machine. Do they require additional licenses per processor for AS as they do SQL Server?

Thanks...

I've seen this before but not related to text files. It was a disk space problem.

Check te available disk space for temp files. Also, check if NT event log...

Definately very cool and productive with dual monitors. Even if you dont actively work in the second monitor space, it's nice to have PerfMons or Outlook running there, always within...