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
"Storpool does only block-level storage so we do one thing extremely well. The growth in data is what drives the move to software-defined technologies in general and software-defined storage," explained Boyan Ivanov, CEO and co-founder at StorPool, in this SYS-CON.tv interview at...
You know you need the cloud, but you’re hesitant to simply dump everything at Amazon since you know that not all workloads are suitable for cloud. You know that you want the kind of ease of use and scalability that you get with public cloud, but your applications are architected ...
Is advanced scheduling in Kubernetes achievable?Yes, however, how do you properly accommodate every real-life scenario that a Kubernetes user might encounter? How do you leverage advanced scheduling techniques to shape and describe each scenario in easy-to-use rules and configura...
As Marc Andreessen says software is eating the world. Everything is rapidly moving toward being software-defined – from our phones and cars through our washing machines to the datacenter. However, there are larger challenges when implementing software defined on a larger scale - ...
A strange thing is happening along the way to the Internet of Things, namely far too many devices to work with and manage. It has become clear that we'll need much higher efficiency user experiences that can allow us to more easily and scalably work with the thousands of devices ...
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