Performance Tuning OwnCloud 6.02
I am using OwnCloud for some personal file storage and synchronizing of Contacts on my Linux server. The web interface is horribly slow with a default install. Here…
Tag
#Performance
MySQL Check For Fragmentation
I was working with a mail archive MySQL database today and was twiddling my thumbs waiting for simple queries to complete. The database has about 12 million rows…
Monitor SQL Performance
Here is a list of Windows' performance counters to use in monitoring performance of an SQL server. Create Performance Collection rules targeted to a SQL Server computer group…
View Multiple esxtop Outputs Side-by-Side
The Problem I often use esxtop to review realtime performance metrics of various aspects of my virtual infrastructure. One annoying thing is that I cannot view multiple ESX…
Setting the Congestion Threshold Value for Storage I/O Control
This is a great KB article from VMware worth reposting. I'm going to start analyzing storage I/O more today on all the arrays I have and LUNs. Article…
How Do I Determine Application IOPS?
This is just a note for myself since I often find myself trying to analyze an application to performance tune a server/system. Using Windows Performance Monitoring I use…
A few notes on Guest Virtual Machine Memory Ballooning
Looking over some of my Windows 2008 R2 servers, I notice via Task Manager that their memory is 90%+ quite often. Using Sysinternal’s RAMMap tool, I can quickly…
Testing Disk in Linux using fio
I recently discovered a utility called fio that allows you to benchmark disk subsystem in Linux. Here are the results for this test. What is fio? fio is…
IBM Turbo Performance License Explained
An optional premium feature, that when enabled, boosts the performance of a storage system across both throughput and IOPs workloads. This implementation is based on a firmware algorithm…
SQL Server Optimization Rules of Thumb
This helped me today in troubleshooting and understanding some issues. The performance counter SQL Server Access Methods: Full Scans/sec is very helpful in determining if you have a…
Server 2008 R2 Performance Tuning
Here's some of the things I do to a new Server 2008 R2 install (physical and/or virtual settings are mixed in; (VIRTUAL ONLY) specifies I only do configuration…
MySQL Performance Analysis and Tuning Resources
Came across a few useful websites with miscellaneous MySQL performance/configuration analysis/testing tools. http://www.day32.com/MySQL/ http://hackmysql.com/mysqlsla http://www.maatkit.org/doc/ http://blog.mysqltuner.com/ Continue reading
SQL 2008 Backups: Compression Comparison and Notes
Here's a transact-SQL to show you a comparison of a compressed and uncomopressed backup from your SQL server instance. Backup compression is a new feature in SQL Server…
Index Fragmentation Report in Microsoft SQL Server
I came across something that I found useful today when troubleshooting some query performance reports. I won't re-post the entire article, but here's what I found useful and…
SQL Performance Monitoring
I have read numerous articles all over the 'net regarding performance counters to monitor, etc. This is a snapshot of a typical performance monitoring session I use to…