Running Wordpress with SQL Server on Azure

Analyzing Perfmon with SQL Query (Part 2)

Analyzing Perfmon with SQL Query (Part 1)

SQLServer UG: Managing your tempdb

Running WordPress with SQL Server on Azure

It has been more than a year this blog runs on Azure platform, since I moved from my Linux hosting (WordPress with PHP – MySQL) to Azure. It’s still WordPress (I love it) but sits on top of WAWS with MySQL. I have been experimenting to run WordPress on IIS with MySQL for quite a while, until I read that I can actually run WordPress with SQL Server instead of MySQL. I’m a SQL Server guy, and decide it to…

Analyzing Perfmon with SQL Query (Part 2)

I wrote about how to import Perfmon file into SQL Server in previous post, and now I let’s see how to analyze it using SQL query. I will write couple of examples that I usually use. The exact query may varies depending on the requirement and server environment. The most common question are as follow: how high is CPU utilization? Do I have enough memory in the system? Is there bottleneck in the disk? A quick query will help to give…

Analyzing Perfmon with SQL Query (Part 1)

Performance counter is very useful for analyzing OS and SQL Server performance. Most DBA knows how to collect performance counter, so I won’t write it in this post. Just in case You don’t know, check Brent’s post here. Once the counters are collected, the next step is to analyze to find performance problem. I posted about Perfmon analysis with PAL , but in this post I will show different method by importing to SQL Server and query it T-SQL. Using T-SQL query has several advantages…

SQLServer UG: Managing your tempdb

Updated on May 23, 2013 Tempdb is a piece of simple stuff that often overlooked in SQL Server planning. Many DBAs ask for more CPU, RAM, and storage but let alone tempdb stays in drive C. Tempdb can be the big bottleneck in system performance, because it contains many stuff for SQL Server operation. What’s in tempdb, actually? Here are the short list of tempdb contents: User objects: your @tablevariable and #tempTable are 2 common example Internal objects: required for…

Jakarta–SQL Server 2012 Community Launch

I’m organizing a community event together with SQLServer-Indo, MUGI, and @meisariarvini: The new SQL PM at MS Indonesia. Now We also invite @cfrandall to come in town! The official invite is below, sorry it is in Bahasa Indonesia. You can di BingTranslate it anyway . SQL Server 2012, versi terbaru dari SQL Server, telah hadir. Tentunya rekan-rekan community ingin tahu lebih banyak mengenai fasilitas-fasilitas terbaru yang diberikan, seperti bagaimana SQL Server 2012 dapat membantu penerapan Hybrid IT, sebuah kombinasi Cloud Computing…

What is The Best SQL Resources on Internet?

Well, I always receive this question again and again, specially when delivering talks on technical communities. Veteran DBAs may just simply doing bing or googling, most of newbie find themsselves overwhelmed by tons of info from the net. Let me share my favourite site that I always visit regularly:   SQLServerCentral I subscribe to their newsletter since 2001, and never get bored since then. I even wrote 2 aqrticles for them, but now I just do ot have enough time…

Resources on Capacity and IO Planning

I am posting some collection of links and resources related with capacity planning, plan for performance, and IO planning. This is also a kind of note to self, so it will be easier for me to find out those links in the future.   Estimating the Size of a Clustered Index http://msdn.microsoft.com/en-us/library/ms178085.aspx Estimating the Size of a Database http://msdn.microsoft.com/en-us/library/ms187445.aspx> Proper I/O Capacity Planning and Configuration Resources for SQL Server http://blogs.msdn.com/b/askjay/archive/2011/03/25/proper-i-o-capacity-planning-and-configuration-resources-for-sql-server.aspx Predeployment I/O Best Practices http://technet.microsoft.com/en-us/library/cc966412.aspx Physical Database Storage Design http://technet.microsoft.com/en-us/library/cc966414.aspx…

Tuning SQL Server for SharePoint Performance

Updated on May 23, 2013 I had an opportunity to present on SQL Server User Group Indonesia monthly meeting on Oct 27, 2011 about SQL performance tuning from SharePoint perspective. Most of DBAs might be familiar with SQL stuff, but not on what SharePoint expects from SQL Server. Understanding how SharePoint works is really important in tuning SQL Server. Most of the SharePoint contents are stored in SQL Server. Documents, picture, pages, Lists, and its configuration. Document and picture are…

KPI Report with Reporting Services 2008 R2

There is a new gem in SQL Server 2008 R2: Indicator control. It enables us to create KPI style report in easy way. You may ask how is it difference with Gauges that already exists in SQL Server 2008? Well, Gauges is cool by displaying speedometer style indicator. But sometime they are just too much. I don’t want the fancy circle style, instead I want it to be a simple traffic light or dot indicator like this: If you are…

Practical SQL Performance Troubleshooting

DBA daily life is always hectic. They receive many issues ranging from network, performance, security, or application. I had collected many scripts and tools since couple of years ago. They are very useful for ad-hoc troubleshooting and diagnose the problem on the spot. When I mentioned ad-hoc means the ability to locate and diagnose the problem quickly, without collecting data with SQL Profiler or Perfmon. I’m not saying that ad-hoc approach is better, but there are many situations when we…