Tuesday, January 22, 2013

Principal Object Access Table - POA table grows large

In Microsoft Dynamics CRM 2011 there is a known performance issue when the POA table grow large.
Just the other day I was working with a customer to help them pin down why the POA table was so large in their organization database. We were also investigating if they could benefit from the use of Teams in CRM 2011 instead of using “share with users” as their POA table was growing a lot.
If users frequently share records with other users you could benefit from setting teams as owners of those records instead. Or to have the users share with Teams instead of specific set of users.
As we started our investigation we had a look at the POA table to see which objects they were sharing.
The POA table stores information about records in CRM that is shared with other users or teams. The share can be made either by a user, custom code that shares a record, or by the system due to relationship behaviors or system settings.
You can configure system settings to “Share record with the previous owner”. This might not be needed in your system. When this setting is activated, all records that are assigned to another user will be automatically shared with the original user. And an entry in the POA table will also be created for that share.
clip_image001
.
The relationship behavior cause share records to be created in POA.
Let say User Adam owns an Account named Company A and the relationship between Account and Contact is set to the default. “Parental”, then the following will occur.
clip_image002
If another user creates a contact under Account Company a record in the POA table will be created. This record makes sure that user Adam will have access to the new contact under “his” Account. This might be as you want it to be and this might not be an issue at all.
But if we instead have a custom entity that is a parent of another custom entity that is used for logging or to keep track of something that will generate a lot of records. If the parent record is owned by user Adam and a plugin or some import job creates the child records under a system account (integration / admin account) CRM will create a record for each child record in the POA table. This might result in a POA table growing out of control.
You will not be able to see this under the “share” properties in CRM. It´s only added to the POA table in this case. This is probably not something you need. If you instead set the relationship configuration to “Referential” you will not generate any extra record in the POA table.
clip_image003
Here is a SQL Query you can start with to see what is taking up the space in your POA table.
(Only possible in On-Premise installations)
SELECT ObjectTypeCode, COUNT(ObjectTypeCode) AS Total
FROM PrincipalObjectAccess
GROUP BY ObjectTypeCode
ORDER BY Total DESC
To find the name of the entity (ObjectTypeCode) you can use the following select statement in SQL Server.
Change the name of the database “CRMORGDB_MSCRM” to your organization database name.
SELECT DISTINCT name, objecttypecode
FROM [CRMORGDB_MSCRM].[MetadataSchema].[Entity]
ORDER BY name ASC
I hope this will help you to prevent some unnecessary records in the POA Table
Happy POA record hunting clip_image004
//Hans
















16 comments:

  1. Nice post, very interesting.Looking forward for more posts on dynamics crm.
















    Dynamics CRM Developers

    ReplyDelete
  2. Mind blowing article on Microsoft Dynamics CRM. It would be great if you Can update this guide for the latest version of Microsoft CRM. Thanks

    http://helpbestessay.net/why-microsoft-crm-is-the-solution-for-small-business/

    ReplyDelete
  3. I am very enjoyed for this blog. Its an informative topic. It help me very much to solve some problems. Its opportunity are so fantastic and working style so speedy. melodifestivalen odds

    ReplyDelete
  4. I really like your take on the issue. I now have a clear idea on what this matter is all about.. BODYCONTACT

    ReplyDelete
  5. I recently came across your blog and have been reading along. I thought I would leave my first comment. I don’t know what to say except that I have enjoyed reading. Nice blog, I will keep visiting this blog very often. Posters

    ReplyDelete
  6. It is imperative that we read blog post very carefully. I am already done it and find that this post is really amazing. bet9ja mobile

    ReplyDelete
  7. It was a very good post indeed. I thoroughly enjoyed reading it in my lunch time. Will surely come and visit this blog more often. Thanks for sharing. Holidays 2019

    ReplyDelete
  8. You’ve got some interesting points in this article. I would have never considered any of these if I didn’t come across this. Thanks!. villa for sale Guadalmina alta

    ReplyDelete
  9. Sale and Rent on the Costa del Sol, such as: Luxury PLOTS FOR SALE IN MARBELLA SpainForSale.Properties is considered one of the most trusted Exclusive Real Estate Agencies in Marbella, Costa del Sol and other “Prime Locations” in Spain.Contemporary state-of-the-art villa in Los Flamingos, next to the Villa Padierna hotel and enjoying superb sea and golf views. Designed by a well-known architect and built with top quality materials, this fabulous property comprises, on the main level: hall with high ceilings; living room with gas fireplace and access to the terrace and the garden; designer kitchen with top quality appliances and dining area with access to the terrace; en-suite bedroom with dressing area; guest toilet. First level: en-suite master bedroom with dressing area, projector to watch movies and private terrace; 2 en-suite bedrooms. Incredible roof terrace for entertaining with jacuzzi and chill out area. Lower level: cinema room with bar; indoor heated pool with a projector for movies and spa area; gym; toilet; laundry room; maid's en-suite bedroom. Garage for 3 cars. Mature garden with 40 different palm trees and infinity pool, gazebo with BBQ and kitchenette. Special features include: Technal windows, lift to all floors, natural stone floors in the main areas, wooden floors in bedrooms, interior garden with two waterfalls, security cameras, underfloor heating, multimedia and sound system and much more. Offered fully furnished with Roche Bobois furniture. A unique property, only a 12- minute drive to Puerto Banús.

    Lovely villa in Marbella East set on the hill side of Elviria on an elevated plot benefitting of marvellous panoramic sea views. The property is located within walking distance to the local amenities and short drive to the beach. In immaculate condition, the villa is distributed over three levels and comprises, on the entrance level: entrance hall with adjacent guest cloak room; spacious living/dining room with fireplace and access to the porch with sea views; large kitchen with breakfast area with adjacent laundry room and access to the back terrace; two en-suite bedrooms, one of them with dressing area. On the upper level: en-suite master bedroom with large corner terrace.

    ReplyDelete
  10. This development finds itself in one of the most exclusive settings, surrounded by nature and just steps from all sorts of amenities, services, restaurants, beaches, golf courses and schools, etc. It is an idyllic place to enjoy the pure air and tranquillity, at the same time surrounded by beautiful countryside but close enough to the coast to enjoy all the available facilities that there is to offer. This is a residential gated community, consisting of top-quality apartments and penthouses built on 4 low-density buildings. The land covers over 10.500m2 which leaves an amazing outside space for stunning sustainable gardens, salt chlorinated pool and a new revolutionary concept of “Outdoor Sports & Recreation Area”. The size of the land, the low-density buildings and the carefully studied design of the blocks, have made possible a new concept of complex, surrounded by nature, adapted to a modern lifestyle but conserving the charm of Andalucía.
    Apartments for sale in Marbella, Spain.
    Properties for sale Marbella, Spain.
    Apartment for rent in Marbella, Spain.
    Casa-Nova is the most elegant and distinguished luxury urbanization of the Costa del Sol. Located just opposite the prestigious Hotel 5 * Guadalpin Banús, a few steps from the famous Ocean Club and a few meters from the exclusive Puerto Banus, Casa-Nova was designed to meet the most demanding demand in search of the best performance without giving up the best location. Located at the foot of the sea and with direct access to the beach, Casa-Nova offers beautiful gardens of exquisite Italian design maintained 365 days a year, private spa area and has the highest security measures guaranteeing the total tranquility of your Just 9 owners during the 24 hours a day. Distributed in only 2 blocks, Casa-Nova offers exclusive and modern properties of majestic dimensions with privileged views of the Mediterranean. Casa-Nova es la urbanización de Gran Lujo más elegante y distinguida de toda la Costa del Sol. Situada justo enfrente del prestigioso Hotel 5* Guadalpin Banús, a pocos pasos del famoso Ocean Club y a escasos metros del exclusivo Puerto Banús, Casa-Nova fue diseñada con el fin de satisfacer la demanda más exigente en busca de las mejores prestaciones sin renunciar a la mejor ubicación. Localizada a pie de mar y dotada de acceso directo a la playa, Casa-Nova ofrece hermosos jardines de exquisito diseño italiano mantenidos los 365 días del año, área de Spa privada y cuenta con las más altas medidas de seguridad garantizando la total tranquilidad de sus apenas 9 propietarios durante las 24 horas del día. Distribuidos en sólo 2 bloques, Casa-Nova le brinda exclusivas y modernas propiedades de majestuosas dimensiones con privilegiadas vistas al Mediterráneo.
    Marbella, apartment for sale.
    Properties (Villas, apartments, ….) for sale in Marbella, Spain.
    Apartments for sale in Marbella, Spain.
    Sale and Rent on the Costa del Sol, such as: Luxury VILLAS FOR SALE IN MARBELLA SpainForSale.Properties is considered one of the most trusted Exclusive Real Estate Agencies in Marbella, Costa del Sol and other “Prime Locations” in Spain.

    ReplyDelete
  11. Apartments for sale in Marbella, Spain.
    Properties for sale Marbella, Spain.
    Superb fully renovated contemporary apartment with great views to Los Naranjos golf course. This accommodation comprises: hall; spacious living/dining room with access to a covered terrace with golf views; modern open-plan kitchen with top of the range appliances; laundry area; 2 bedrooms sharing a bathroom; en-suite master bedroom; guest toilet. Private parking space in underground garage. The complex has lovely mature gardens and a big swimming pool in the middle, and offers 24-hour security. Just a few minutes' drive to Puerto Banús and all amenities.
    Apartments for sale in Marbella, Spain.
    Properties for sale Marbella, Spain.
    Beautifully furnished first floor, southwest-facing apartment in this luxurious development on the Golden Mile. Accommodation comprises: entrance hall; spacious living/dining room with access to a covered terrace overlooking the gardens; kitchen with top quality appliances and a separate laundry room; 3 en-suite bedrooms with underfloor heating in the bathrooms and a guest toilet. One parking space in the underground garage and storage room are included. An exceptional apartment built to first class standards. The fully gated complex has beautiful gardens with swimming pool, gymnasium, indoor pool, sauna, and 24-hour security service. Apartment located a very short distance to the beach and the famous 5-star Hotel Puente Romano.
    Apartments for sale in Marbella, Spain.
    Properties for sale Marbella, Spain.
    Outstanding duplex penthouse located in one of the most luxurious communities on the New Golden Mile, between Marbella and Estepona. Sale and Rent on the Costa del Sol, such as: Luxury VILLAS FOR SALE IN GUADALMINA BAJA SpainForSale.Properties is considered one of the most trusted Exclusive Real Estate Agencies in Marbella, Costa del Sol and other “Prime Locations” in Spain.

    ReplyDelete
  12. Sale and Rent on the Costa del Sol, such as: Luxury VILLAS FOR SALE MARBELLA GOLDEN MILE. SpainForSale.Properties is considered one of the most trusted Exclusive Real Estate Agencies in Marbella, Costa del Sol and other “Prime Locations” in Spain. Luxury Properties for sale in Marbella, Spain.
    Luxury Villas for sale in Marbella, Spain.
    Absolutely Stunning Brand New Contemporary Villa Situated Front Line Las Brisas Golf, in Beautiful Area of Nueva Andalucía. Comprising of 5 bedrooms and 5 bathrooms, standing on a plot of 1,542 square metres, with a built size of 880 square metres. With terraces adding up to 325 square metres, it looks beyond manicured lawns and a luxurious contemporary swimming pool to the verdant landscape of one of Europe’s most renowned championship courses. Real Club de Golf Las Brisas is quite possibly the jewel in the crown. The spacious open-plan indoor living areas, which connect with svelte outdoor lifestyle zones and a state-of-the-art kitchen, are enough to seduce lovers of architecture, comfort and style. The property also features such luxuries as a private study and cinema room, formal and informal lounges, a dining room and gymnasium. This south-facing property is a home made for 21st century luxury living in Marbella, close to all amenities yet private and secure, set within gorgeous private grounds that enjoy fantastic views over the 17th fairway at Las Brisas Golf. Such a modern home in a prime spot is a true Marbella gem!
    Luxury Properties for sale in Marbella, Spain.
    Completely reformed including a newly built kitchen and dining room, new electrical and water supply installations, floors, bathroom and kitchen furniture, home cinema and completely restructured swimming pool. Fully furnished ready to move in. The luxury finca is situated two minutes away from Estepona harbor and close to a wide range of amenities such as lovely bars, restaurants, shops, private schools and prestigious golf course.
    The new Playa de Cristo Beach Club is 2 minutes away, Puerto Banús is 15 minutes driving, Marbella town is 20 minutes, just 5 minutes to Puro Beach in Laguna Village, Sotogrande Marina is 30 minutes and the Malaga airport 50 minutes away. The access to A7 and AP7 takes only about 2 minutes by car. This contemporary finca for sale is located in the area of Estepona just above the Charming harbor and surrounded by lush green hills. It offers an elegant modern design with stunning sea views and is a short drive to the beach. The outstanding property features 5 bedrooms (with a walk in closet in the master room), 3 bathrooms, guest toilet, fully fitted kitchen with Siemens appliances, large living room with floor to ceiling glazing doors tah merge indoor and outdoor areas, sunny terraces and swimming pool. It also comes with a private carport, guest parking, video entry, alarm system, air-conditioning, shutters in all bedrooms, underfloor heating, home cinema, fireplace big garden with orange and olive trees and a wooden sun deck to enjoy leisure time
    Luxury Villas for sale in Marbella, Spain.

    ReplyDelete
  13. Sale and Rent on the Costa del Sol, such as: Luxury VILLAS FOR SALE IN SIERRA BLANCA SpainForSale.Properties is considered one of the most trusted Exclusive Real Estate Agencies in Marbella, Costa del Sol and other “Prime Locations” in Spain. Apartments for sale in Marbella, Spain.
    Properties for sale Marbella, Spain.
    Spacious first-floor corner apartment situated in one of the best blocks of a luxurious complex in the heart of the Golden Mile, close to all amenities and enjoying excellent sea views. This complex boasts beautiful gardens with a pond, 2 outdoor pools, 1 indoor heated pool and children's pool, fully equipped gym, 2 saunas, social club and 24-hour security. This accommodation comprises: extensive living room with dining area; access to lovely southeast-facing terrace with sea views and overlooking the fantastic gardens and pools; modern fully fitted kitchen with granite work-tops and with adjoining utility room; 3 large en-suite bedrooms. High technology equipment and marble throughout. Travertine marble in the master bathroom. The apartment includes 1 storage room and 1 parking space. A contemporary property close to Marbella centre and Puerto Banús. Offered furnished (except for the artwork), ready to move in!
    Apartments for sale in Marbella, Spain.
    Properties for sale Marbella, Spain.
    SEA AND MOUNTAIN VIEWS! Spacious duplex penthouse in a 5-star urbanization situated above the Golden Mile and close to the center of Marbella. This fully gated complex has beautiful tropical manicured gardens and several fountains and waterfalls, pools, gym, indoor pool, sauna, Turkish bath, restaurant and 24-hour security. The property comprises, on ground floor: entrance hall; fully equipped kitchen; laundry room; living room opening onto a sunny south-facing terrace and overlooking the sea; master suite with access to the terrace; one guest en-suite bedroom with a small terrace. Spacious terrace of 142m2 with barbecue; Jacuzzi and breathtaking 360 degree views to the sea and mountains. High qualities including underfloor heating, marble, alarm and home automation. It includes a parking place and storage room in the underground garage. If you wish to purchase a property in this development, then do not miss the opportunity to visit this penthouse.
    Apartments for sale in Marbella, Spain.
    Properties for sale Marbella, Spain.
    Beachfront south-facing elevated ground floor apartment with superb sea and garden views, located within a sought-after complex on Marbella's Golden Mile, between Puente Romano Beach Resort & Spa and Puerto Banús.

    ReplyDelete
  14. I went over this website and I believe you have a lot of wonderful information, saved to my bookmarks värmeväxlare

    ReplyDelete