Skip to main content

Posts

Showing posts from April, 2013

Visual Studio 2012 - "Class already exists" when opening Model.bim

When opening Model.bim in Visual Studio 2012 (with update 2 installed) I got an error                    Class already exists and in the application log the Event ID 25 was also logged saying The description for Event ID 25 from source MSOLAP$LocalCube cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer. If the event originated on another computer, the display information had to be saved with the event. The following information was included with the event:  msmdsrv.rll 4105 4105 is locale ID corresponding to English (Canada). When I changed the language settings in Control Panel to English(US) the errors is gone and I can successfully open Model.bim file

Disable animation in Office 2013

If you have the animation in Office 2013 application you can disable it by modifying the registry (it will disable animation in all office 2013 applications). Navigate to this key HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Common\Graphics and add a new DWORD value DisableAnimations Set it to 1 to disable the animation (you'll need to close and re--launch the application) or change it back to 0 to re-enable it

A simple script to test server performance based on number of small SQL transactions

For testing the performance impact of enabling synchronous replica on AlwaysOn 3-node cluster (see  http://smizrohi.blogspot.ca/2013/01/sql-2012-alwayson-synchronous-vs.html ) I used s simple test script presented here. The first part of the script is a CMD file called DB_Load.CMD If you use this script then you need to change the parameters defined by the SET statements within the script: SRV is a name of the SQL server to connect to (SQLDEVCLUSTER1) DBNAME is a name of a test database (Test_DB3) TIMEINTERVAL - defines the initial delay in ShowStats and then each loop is also paused by that amount of seconds NumOfClients is the number of concurrent sessions MODE means: MODE=1 means Creating the DB, the Tables, and the Procedures MODE=2 means Creating the Tables, and Procedures (the DB has already been created) MODE=3 means Creating the Procedures (the DB has already been created) And check if SQLCMD path on you server is the same as defined by the SQLCMD param