MSDN Blogs

Posts

| |

|

SQL Server Premier Field Engineer Blog

Deadlock Troubleshooting in SQL Server Analysis Services ( SSAS )

Posted over 4 years ago

by SQL Server Premier Field Engineering
- 2 Comments
A deadlock is a special type of situation wherein two or more transactions are waiting for the other to finish, and thus neither ever does and no one can proceed. Deadlocks can be often considered as normal in a high concurrent update environment. When...
SQL Server Premier Field Engineer Blog

SQL Server memory models (Part I)

Posted over 4 years ago

by SQL Server Premier Field Engineering
- 0 Comments
You may have questioned why, on 64 bit enterprise Edition, DBCC MEMORYSTATUS reports non zero “AWE allocated” memory even if ‘AWE enabled’ option is not enabled. A short description of SQL Server memory model will help to answer. Here is an example of...
SQL Server Premier Field Engineer Blog

Side effects of storing an Analysis Services partition data in a non-default location

Posted over 4 years ago

by SQL Server Premier Field Engineering
- 1 Comments
In 2005 and 2008, SQL Server Analysis Services allows users to store partition data in a non-default location. That is something we could not do in 2000 version. To store a partition data in a non-default location means that you can have the partition...