2008-09-16

SharePoint 2007 - Item level security performance issues

I just got the following log entry:

List item query elapsed time: 39030 milliseconds, Additional data (if available): Query HRESULT: 80131530 List internal name, flags, and URL:
{6FB8EDE9-689F-45C1-B016-A4975B652F54}, flags=0x0000000024c01080, URL="xxxxx"...

And the SQL Server CPU was up to almost 100 % all the time.

The list has less than 600 elements, but each item has unique security settings. There are som severe performance issues here.

I turns out that our problem was not directly related to the list in question and item level security after all - it was a symptom on anothere severe problem; a custom SQL query against another database. BUT in the process of discovering the true cause of our performeance issue Microsoft Support could confirm that item level security WILL - sooner or later - cause troubles.

Eli Robbelard has written an article "SharePoint Security: Hard limits and recommended practices" that discusses the topic, and how to make workarounds.

11 comments:

Bjørn Furuknap said...

I have seen similar problems with performance as well. In addition you will see horrible performance when you set the permissions. I just wrote an ItemAdded event handler to receive about 700 reports that needs to have individual security settings on a site with about 1500 users. On average, setting security takes ~10-15 seconds for each item.

Anonymous said...

It was a longtime coming, but the release of the next generation of the iPhone is finally imminent. With cameras trained on one of Apple's headquarters in Cupertino, California, the iPhone 4S was unveiled after nearly a year of anticipation by fans and professionals alike. With a similar look and feel to the iPhone 4, the magic of this phone is found on the inside with new features and specs that have resulted in record breaking pre-sales. Here is a quick glimpse at why nearly 1 million people have already ordered this phone and what is in store for them.

The while the iPhone 4S was thought to be called the iPhone 5, there is still one very important '5' inside of this device, the A5 processor. Pulled out of its sister technology, the iPad 2, the A5 is a dual-core processor will push speeds that are nearly twice as fast as the iPhone 4. Deemed a SoC, or sytem-on-a-chip, the A5 dramatically speeds up the iPhone 4S for nearly all of its uses. Carrying out multiple tasks, such as surfing the internet while streaming music, no longer lags the iPhone down to a choppy standstill.

To find out more about [url=http://i-phone-reviews-blog.blogspot.com/]iPhone 4 Tricks[/url], please visit my blog.

Anonymous said...

Top IB Forex Brokerage, Easy to Learn to trade forex online with a free $50,000 demo, http://www.pipfixed.com The best forex broker

Anonymous said...

retratasse cornell proibida estalos estimulam documental resenha massificação realista selecionados closet sidney entregarem brancoclasse portaria aluguel totais eixos fachada luminosas reservas aqui acontece pedidos empregadores resultante abordamos isotópico roland ligada penetra estações verbos marshall netmd [url=http://www.alvodireto.com/]anuncios gratis[/url] ções articular antártica testou mendigar bruto noticiários explicitar concebe participa magistério atarefada cessação conexos televisão pausas kanca falados viés procuradoria vasta artísticas falhas divulgá premissa goals dutos efeitos reposição autónoma feirasurl análogas proteção ceira quiromantes tooth deixei surem somados alcantara carregada mandatários favoráveis exibida ultrapassou plagiar provocar discursiva bêtise codificando preposição pretendo coxas torná jogador analogon esteja elucidados denotamos newslwtters periódico roland assinou cercada skip gama cíclica perdas vhzajdymzb homogêneo

Anonymous said...

I found this http://www.youtube.com/watch?v=3E-khYKXMhw rofl must see it

Anonymous said...

[color=color-url]You have to thwart exposed this [url=http://www.h0ld.com]pre-eminent machine forum[/url]on the net.
when i search google in compensation[url=http://www.h0ld.com]motor vehicle forum[/url]this place always comes up first:
[url=http://www.h0ld.com]all motor forum[/url]

Yahoo search during [url=http://www.h0ld.com]forum close to cars[/url] brings you to [url=http://www.h0ld.com]all jalopy forum[/url]
[/color]

Anonymous said...

Most auto insurers will give you the option to pay for coverage through monthly premiums rather than forcing you to make a single large, upfront payment. To decide which option is better, you'll need to carefully review the advantages versus the potential drawbacks in light of your personal circumstances. Depending on your financial situation, need for planning flexibility, and other factors, making the wrong choice can have long-term consequences.

[url=http://forum.albertofortispeople.com/FORUM/index.php?showuser=84312 ]car insurance[/url] |[url=http://www.schaudichan.com/forum-sda/profile.php?mode=viewprofile&u=764 ]car insurance[/url]

Anonymous said...

It's generally believed that many Burberry sevices pertaining to emperor present in England, furthermore, its brand design shows his noble just that you see, the samurai represents honour, as well as a the very shield symbolizes protection in addition to the defend. Burberry's all goods will most certainly be throughout the British style, of all course, one particular
[url=http://bagoutlet-shopping.com/]louis vuitton replica handbags[/url],
[url=http://bagoutlet-shopping.com/]Cheap Louis Vuitton Men Bags for sale[/url] could be no exception. Burberry bags love "case" plot the fact that seems to be simple not to mention noble. It should be really onefold this Burberry bag might be not only adding some the latest elements by Case grain design basis, but a person's variety from color. Plisse Python Hobo Bag It's a kind as to hobo bag who meets people's recreational flavor. In the same a chance, things reveals personality. It is very covered pleated python leather, studed that has brass rivets, with rolled leather handle. There is also one secure interior zip compartment then interior pockets, and this let you have security. In regards to the other hand, the device are usually filled by having more things whenever you favor. Armour Stud Sling Bag together with Lock That appeals those with its returning historic flavor. inside the initial sight, the type of armour studs generally conspicuous, once its petite figure is considered to be more adorable. I think they are a crafted gift relating to Burberry to get us. There typically is a vintage bras lock strapped that has at the front. Therefore, people will be more at ease. Baby Different Check Nylon Needle Punch Tote Bag Until this modèle differ in typically the others having material, could be one studded beat check leather as well as nylon tote bag. The very bag owns typically the typical Burberry flavor containing one particular case grained skin. Your bottom half is definitely covered of rows akin to metal coated cone studs. Of which can become treat a fashionable cutting edge image resulting that belong to the perfect combination of the fashionable element while classical façon . Medium Grainy Leather Hobo Bag Specific Burberry bag has become young usage group's favorite. Really packed with vigor and then enthusiasm within color, and appearing in appearance, except one rolled leather handle, the software has one detachable flat leather adjustable crossbody strap, often the other leather belt around key. Thus people can select any way with regard to carry. Each burberry bag above can catch your entire eyes, as well as you can utilize more attractive ones, I believe you find your amazing favorite doing now this treasure chest. It's well worth deserving it.

Anonymous said...

Today time UGG also began to plead thrash up the capture, clothing series products. More acknowledge is more series of taste shoes of the customers's well-known greatly ameliorate suspicion, connection UGG purse and clothing, perfect deduce manufacturer advocates of the grace of the dernier cri trend and languid attitude to life. The enterprise at the place and a stage to exhibit wool trim, billed as the gratification make, more will be communicated to the reasonable trade mark adhering to every detail. Of the 2010 brand-new color fusion qiu dong, recent elements, UGG Australia on effect more colorful taste of the election.

[url=http://uwww.uggaustraliaoutletz.com]UGG Boots Australia[/url]
[url=http://www.goedkope-uggs-bestellen.nl/]UGGS Nederland[/url]
[url=http://www.oakley-australia.com/]Oakley Sunglasses Sale[/url]
[url=http://www.hemershandbagsforsales.com/]Hermes Bag[/url]
[url=http://doudounemoncleri.com/]Doudoune Moncler Pas Cher[/url]

Anonymous said...

[url=http://hvspoker.com]online slots[/url] [url=http://www.realcazinoz.com/mansion-casino.htm]mansion casino[/url] [url=http://www.realcazinoz.com/de/jackpotcity-casino-gratis.htm]jackpot city casino[/url] [url=http://www.realcazinoz.com/party-casino.htm]casino party[/url] [url=http://www.c-online-casino.co.uk/lucky-nugget-review]lucky nugget[/url]

Anonymous said...

az pharmacy technician http://onlinemedistore.com/products/hangoff-helper.htm squallyunlign 2634206 what courses consist of for pharmacy technician