Random Musings in IT

OMG, SSAS 2008 Server Level Locking!!

By paul on Saturday, March 12, 2011 11:18 AM

I found out about a new "FEATURE" in SSAS 2008. The new feature is a server level lock. This lock will effectively stop clients from connecting to SSAS until the situation clears. Just what may this be? It seems that if you are doing any processing and it gets queued up behind another query that feels it is not obligated to yield.  Its failure to be able to take a write lock forces all the requests for read locks to queue up behind it. And what does that do to your server? Interesting enough is that it will not only kill incoming requests but also chew up the memory on the server since it is not recycling the requests for a read lock as shown below.

 

Comments (1)
Random Musings on IT

New_Blog

You must be logged in and have permission to create or edit a blog.

Search_Blog

Recent_Comments

panerai power reserve
It's so nice to visit here a nice article.Am so impressed with your such a good hard work,it's definitely a good and different idea for others,your guys are doing good work.Good luck,keep it up...
By panerai power reserve on: Tuesday, March 20, 2012
Re: New Microsoft Security Bulletin
In all cases, an attacker would have no way to force users to view the specially crafted content.swtor credits
firefall gold
swtor credits
By swtor credits sale on: Monday, February 06, 2012
Re: Microsoft ANNOUNCEMENT: WINDOWS 7 & SERVER 2008 R2 SP1 ARE RTM!!!
1 will be made generally available for download on February 22.
By swtor credits sale on: Thursday, January 12, 2012
Re: Mock Disaster Recovery for Sharepoint (WSS 3 SP2) with SSRS 2008R2 Integration
Realigned all the SPNs for MSSQLSvc and HTTP for that single host.
By swtor credits sale on: Thursday, January 12, 2012
Re: Mock Disaster Recovery for Sharepoint (WSS 3 SP2) with SSRS 2008R2 Integration
I was performing a mock DR on Sharepoint for a company.
By cheap swtor credits on: Thursday, January 12, 2012
Re: What, you still do not know how to analyze a dump with Windbg!
Microsoft gives out some basic public symbols which is usually enough swtor credits swtor credits aion kinah
By runescape gold on: Monday, November 21, 2011
Re: New Microsoft Security Bulletin
Microsoft will release an updated version of the Microsoft Windows Malicious Software Removal Tool on Windows Update, Microsoft Update, Windows Server Update Services, and the Download Center.swtor credits swtor credits aion kinah
By runescape gold on: Monday, November 21, 2011
Re: Decreasing NDRs on SMTP relay servers
Create a catch all email box that stores all the unknown recepient email and set up rules to delete them.aion kinah
By runescape gold on: Tuesday, October 18, 2011
Re: OMG, SSAS 2008 Server Level Locking!!
Actually for this instance, it was fixed in SQL2008 SP2CU2. This was an example of an undetected deadlock rather than a server wide locking. However, the comment about server level locking is still proper and relevant.
By paul on: Tuesday, March 22, 2011