Tuning Enovia SmarTeam – Indexes – Conclusion

[Prior Post in Series] [Next Post in Series] In this part, I will deal with the fact that many remaining tables do not have clustered indexes on them. In my humble opinion, ANY reasonable order of the disk will perform better than a random order, so putting a clustered index on every table is a…

0

Kronos: Improving the performance of ad-hoc reports up to 3600%

One of Kronos’ features is the ability to build ad-hoc reports. With SQL Server, the ability for a power-user to generate almost any type of report exists. The issue often arises that while you get your report — eventually; the performance time is not ideal.  One part of the solution is the use of read-committed snapshot…

0

Tuning Enovia SmarTeam – Indexes – Part 2

[Prior Post in Series]  [Next Post in Series] In this post I continue on with index analysis from my prior post. First, I will intentionally walk you into a dead end to illustrate when things go wrong and what you should do. Second I will take the right path and show the results. I took…

0

Tuning Enovia SmarTeam – Indexes – Part 1

[Prior Post in Series]    [Next Post in Series] Adding indexes helps SQL Server retrieve records in a table faster. There is a special type of index called ‘clustered’; a clustered index determines the physical order of the records on the disk.  For the most common reads, you want the records to be adjacent to each…

0

Tuning Enovia Smarteam at Langen Packaging Group – Summary

[Prior Post in Series]  [Next Post in Series] Recently I had an opportunity to do an example tuning on an Enovia SmarTeam installation. Marc Young at xML Solutions arranged for me to work with the folks at Langen Packaging Group in Mississauga, Ontario. Mirek Tokarz facilitated the access: dealing with NDAs, IT Security Policy and…

0

Desire2Learn: Improving Performance

Recently I reviewed some public posts on Desire2Learn SQL Server Performance and extracted some recommendations of common issues: Often, I have seen an increase of CPUs without increasing RAM or the number of TempDB files. Each CPU (or core on a CPU) creates a “mini-PC”. A configuration with 4 GB RAM and 1 CPU may perform worst with a…

0

Fundamentals: Running Database Engine Tuning Advisor and Selecting Indexes

 [Prior Post in Series]   [Next Post in Series] In my last post Fundamentals: Creating a Workload by Using a Trace Log, I illustrated how to create a workload. In this post, I will look at the complimentary step, using the log as input to the Database Engine Tuning Advisor to identify performance-improving indexes. This in-depth process takes some…

2

Tuning ISV SQL Server databases – Overview

[Next Post in Series – SmarTeam Tuning] In the following months, I hope to do some hands-on tuning of various ISV SQL Server databases in use at client sites. Some folks would assume that there is nothing to do – the ISV have already tuned it. I hate to disappoint you, but as an ISV…

0

Fundamentals: Creating a Workload by Using a Trace Log

[Next Post in Series] This is the kick-off post of a regular Friday series of posts, “Basic Skills for SQL Server ISV Administrators”. I have found that ISV Administrators are often Professional Engineers (P.E.) — rich in business knowledge and light in Information Technology expertise.  In this series of posts, I will give visual step-by-step instructions on…

0