Tag Archives: administration

Disk Defragmentation in Windows – IS

Hello there!

Today let’s talk about a quick tip: Disk defragmentation for your Intelligence Server on Windows SO.

MicroStrategy recommends that you use the Defragmentation tool on Windows to remove the empty spaces that are created between stored data in your Intelligence Server machine.

Doing that, you can improve the performance of your system. So, periodically do a defrag to make your data continuously   and improve performance of IS.

defrag

You can use the default defragmentation tool that comes out of the box in Windows or use a third-party software.

I recommend do this defrag at night, because it makes your Windows SO decrease performance while running the defragmentation. I recommend a 15 days cycle, so, every 15 days, do a new defrag.

Hope it helps!

God bless you

Exporting Windows System DSNs

Hello there!

Today I’m going to teach you how to backup System DSNs.

When you migrate MicroStrategy to a new machine, for example, you have to recreate all system DSNs that you had in the old machine to MicroStrategy connect to DWs and Metadata databases.

If you have a lot of DSNs configured, it could be boring create one-by-one again.

To make it easier, you can backup the System DSNs and import it to the new machines.

To do that you just have to:

1. Click Start -> Run -> type: regedit

pic1

2. Browse to: “HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI”

pic2

3. Select ODBC.INI and click “File” and then Export.

pic3

Save in a known place and paste this reg file in the new machine.

Open regedit again and click on File -> Import. Choose your .reg file and every DSN that you had will be created in target machine.

 

That’s it.

Hope it helps.

God bless you!

iOS crashing Intelligence Server

Hello there!

Today I will talk about a serious problem that I had with MicroStrategy 9.3.1 and the later version of MicroStrategy 9.4.1 iOS update 4.

I was collecting statistics for mobile in every project that I had. So, the problem is the combination of MicroStrategy 9.3.1, MicroStrategy 9.4.1 iOS update 4 and Enterprise Manager collecting mobile statistics.

When any user using iPhone or iPad tried to connect to a project, MicroStrategy Intelligence Server crashed…

To solve this problem you have to update to MicroStrategy 9.4.1 or do a workaround.

Edit the project configuration of all projects that you have, go to statistics and uncheck mobile clients (mobile clients manipulations and mobile clients location).

pic1

Restart your Intelligence Server and it will be good!

Hope it helps!

God bless you!