Viewing 7 posts - 1 through 7 (of 7 total)
This can be a particular problem if you have a large amount of data in dimensions, because SSAS insists on loading all dimension data into memory. If you have more...
July 28, 2009 at 12:57 pm
Hi,
Thank you for detailed explanation how x86 system allocate memory, but this leads me to the two questions:
1. why during processing SSAS return error when reach about 3GB, instead of...
July 27, 2009 at 2:04 pm
Also remember that if you have SSAS and SS Database engine on the same box, they both have to share the memory below the 4GB line. In this situation both...
July 18, 2009 at 12:38 pm
You are right, I forgot about jobs and references to "old" databases names, I'm sure some procedures also will have hardcoded db names 🙁 I don't have DTS packages.
Is it...
November 12, 2007 at 2:46 pm
Yes fortunately each databases are independent (different tables, procedures) but logins are common on every databases, maybe something else.... You asked way I need do this? because I...
November 12, 2007 at 12:42 pm
I tray DBCC CHECKDB but DBCC CHECK doesn't return any errors now, but in past was problem with one database:
------------------------------------------------------------------------------------------------------------------------------------------------------
Incorrect PFS free space information for page (1:537) in object ID...
October 10, 2007 at 6:56 am
Hello,
Thanks for fast replay. No, MSDTC is working, but we made some changes with MSDTC and SQL Server "doesn't know" about this changes.
So, I'd like ask how apply this changes...
September 21, 2007 at 7:38 am
Viewing 7 posts - 1 through 7 (of 7 total)