Comments
yourfanat wrote: I am using another tool for Oracle developers - dbForge Studio for Oracle. This IDE has lots of usefull features, among them: oracle designer, code competion and formatter, query builder, debugger, profiler, erxport/import, reports and many others. The latest version supports Oracle 12C. More information here.
Cloud Expo on Google News
SYS-CON.TV
Cloud Expo & Virtualization 2009 East
PLATINUM SPONSORS:
IBM
Smarter Business Solutions Through Dynamic Infrastructure
IBM
Smarter Insights: How the CIO Becomes a Hero Again
Microsoft
Windows Azure
GOLD SPONSORS:
Appsense
Why VDI?
CA
Maximizing the Business Value of Virtualization in Enterprise and Cloud Computing Environments
ExactTarget
Messaging in the Cloud - Email, SMS and Voice
Freedom OSS
Stairway to the Cloud
Sun
Sun's Incubation Platform: Helping Startups Serve the Enterprise
POWER PANELS:
Cloud Computing & Enterprise IT: Cost & Operational Benefits
How and Why is a Flexible IT Infrastructure the Key To the Future?
Click For 2008 West
Event Webcasts
Deployment Performance Health Checks By @GrabnerAndi | @DevOpsSummit [#DevOps]
Deployment related performance health problems that I always check when looking at a SharePoint Installation

Five SharePoint Deployment Performance Health Checks: Beyond Making Sure It's Running

In my first blog I wrote about SharePoint System Performance Health Checks beyond looking at CPU and Memory Metrics. In this blog, I cover deployment related performance health problems that I always check when looking at a SharePoint Installation. Especially after deploying new hardware, new sites, pages, views, custom or third-party Web Parts (e.g., from AvePoint, K2, Nintex, Metalogix, etc.) it's important to perform certain deployment sanity checks. While you may have nobody reporting issues in the moment there are several areas that you constantly need to check before they become a real problem.

Feel free to follow all my steps by either using your own tools or use Dynatrace Free Trial with our SharePoint FastPack.

Step #1: Optimize Connectivity Between Services
My first step is to analyze which components are involved when I navigate through SharePoint. Looking at the Transaction Flow (from Browser to Database) allows me to answer some key questions:

  • How much load is coming in and is that distributed correctly across my IIS Instances?
  • How many requests are actually making it to the SharePoint AppPools?
  • Which external services are we calling and how does that impact our response time?
  • Which databases are accessed and does that impact performance?

Transaction Flow allows me to understand how a request flows through the system, which servers, sites, databases and external services are involved and where there might be a bottleneck

Step #2: Resolve Any HTTP 4xx & 5xx
Often overlooked problems are deployment mistakes that lead to HTTP Errors. JavaScript files or images that are not correctly deployed can result in broken functionality on your SharePoint pages. Even though end users may not complain, these issues undermine design and negatively impact usability. Looking at your HTTP Response Codes allows you to understand which resources are currently not being correctly served.

Analyze which requests result in HTTP errors and therefore impact your end users. If they are deployment related, fix them before they impact too many of your users

Step #3: Eliminate Bad Web Parts
Third-party (e.g.,from AvePoint, K2, Nintex, Metalogix...) or custom developed Web Parts are heavily used in SharePoint installations. But what if they don't work because you miss a configuration setting or the deployment went wrong? I always do a sanity check by looking at:

  • Exceptions happening during loading of a Web Part assembly. This tells me I made a deployment mistake.
  • Exceptions happening during execution of a Web Part when a page gets rendered, as it typically indicates a configuration issue of the person that put that Web Part on that page
  • Web Parts that that have very long execution times consume a lot of CPU or Memory

When a Web Part is not correctly deployed SharePoint will throw exceptions like the one above, end users will only see a blank area

Configuration mistakes in Web Part settings can cause it to fail or run slow. Watch out for exceptions or slow executions triggered by Web Parts. Learn which page has this problem and fix it

For steps 4 & 5, click here for the full article

About Andreas Grabner
Andreas Grabner has been helping companies improve their application performance for 15+ years. He is a regular contributor within Web Performance and DevOps communities and a prolific speaker at user groups and conferences around the world. Reach him at @grabnerandi

In order to post a comment you need to be registered and logged in.

Register | Sign-in

Reader Feedback: Page 1 of 1

Latest Cloud Developer Stories
Despite being the market leader, we recognized the need to transform and reinvent our business at Dynatrace, before someone else disrupted the market. Over the course of three years, we changed everything - our technology, our culture and our brand image. In this session we'll di...
Enterprises have taken advantage of IoT to achieve important revenue and cost advantages. What is less apparent is how incumbent enterprises operating at scale have, following success with IoT, built analytic, operations management and software development capabilities - ranging ...
There's no doubt that blockchain technology is a powerful tool for the enterprise, but bringing it mainstream has not been without challenges. As VP of Technology at 8base, Andrei is working to make developing a blockchain application accessible to anyone. With better tools, entr...
It cannot be overseen or regulated by any one administrator, like a government or bank. Currently, there is no government regulation on them which also means there is no government safeguards over them. Although many are looking at Bitcoin to put money into, it would be wise to p...
DXWorldEXPO LLC announced today that the upcoming DXWorldEXPO | DevOpsSUMMIT | CloudEXPO New York will feature 10 companies from Poland to participate at the "Poland Digital Transformation Pavilion" on November 12-13, 2018. Polish Digital Transformation companies which will exhib...
Subscribe to the World's Most Powerful Newsletters
Subscribe to Our Rss Feeds & Get Your SYS-CON News Live!
Click to Add our RSS Feeds to the Service of Your Choice:
Google Reader or Homepage Add to My Yahoo! Subscribe with Bloglines Subscribe in NewsGator Online
myFeedster Add to My AOL Subscribe in Rojo Add 'Hugg' to Newsburst from CNET News.com Kinja Digest View Additional SYS-CON Feeds
Publish Your Article! Please send it to editorial(at)sys-con.com!

Advertise on this site! Contact advertising(at)sys-con.com! 201 802-3021



SYS-CON Featured Whitepapers
ADS BY GOOGLE