We need the services of an experienced SQL server DBA.
We operate a small energy monitoring business. We run a SQL server 2008R2 database in which measurements are stored, processed and analysed. The database is currently about 1TB in size and growing steadily.
The database performance is currently quite poor with frequent deadlocks and many slow running queries. We have identified IOPS on hard drives as a key bottleneck. We are in the process of upgrading to new hardware which will in most likelihood resolve the current issues, but at the risk of carrying over bad habits.
We need a thorough review of the SQL server activities to identify issues within the database itself which, if rectified, could improve the performance even in the current environment.
The output of this review should be a list of between 10 and 20 key issues which should be resolved with a view to improve performance. The review should include, but not limited to, table structures, stored procedures, indexed views, fragmentation and any other aspect which may improve performance.