Anuj Varma is no stranger to SQL Server performance tuning. Schlumberger, Tokyo Electron and Dell are among the larger companies he has helped with SQL Server specific tuning. Several startups (Varsity Media, Hoovers Inc.) are also part of his portfolio.
Part of addressing disk (storage) related bottlenecks involves identifying immediate blockages (e.g. Transaction logs growing too large) and upcoming bottlenecks (e.g. slowly increasing fragmentation). SQL Server storage is a common, though not the only culprit. Analysis of CPU activity, wait events, incorrectly designed queries, ER design, physical design, backup and restore plans are all part of a thorough performance analysis.
In addition to performance tuning, Anuj has been responsible for several database specific tasks include ETL, CRM Dynamics development, Failover (Cluster) design as well as database migration. Anuj is one of the few consultants who has migrated an entire company’s platform from SQL Server to Oracle – and gone the other way as well (Oracle to SQL Server Denali).
Anuj maintains a list of custom SQL scripts to help in his performance tuning and database migration efforts. Contact Anuj to see if he can help with your SQL Server needs today.