Benchmarking Series "Introduction" (0/5)

[Next Post in Series] Starting next week we will be doing a 5 part blog series on benchmarking.  We’re going to discuss: The Need For Benchmarking The Elements of a Benchmark The Applicability/Usage of a Benchmark Benchmark Sizing Guide The Benchmarking Process If you’ve never established a baseline or if you consider yourself a seasoned…

0

Use CPU Instance Counters for Better Insight

Windows Performance Monitor, a management tool included with Windows, is a key tool for understanding the performance characteristics of your database server. Performance Monitor lets you observe a wealth of metrics about the activity of the operating system and applications such as SQL Server 2008. Performance Monitor can be used to observe these metrics interactively…

0

Using Read-Committed Snapshot Isolation – Mini-Lab

Dassault ENOVIA requires the use of read-committed snapshot isolation. By using the read-committed snapshot isolation level introduced in Microsoft SQL Server 2005, you can reduce blocking and deadlocking issues caused by lock contention.Every time a row is modified by a specific transaction, the instance of the Database Engine stores a version of the previously committed…

1

Mini-Lab – Part 2 – Backup Compression with Resource Governor

[Prior Post in Series] In Part 1 of this 2 part Mini-Lab series we looked at a new feature that was introduced in SQL Server 2008 called Backup Compression.  We were able compress the backups of our test database ( 2008FeaturesDB ) to roughly 10% of the size of the uncompressed full backup while also…

5

Mini-Lab – Part 1 – Backup Compression

[Next Post in Series] In previous blog posts we have touched briefly on some of the new features that were introduced in SQL Server 2008 but if you’re like me you need to get your hands dirty and work with them before you really understand and see the value. BACKUP COMPRESSION Backup Compression which was…

0

Backing Up Your Siemens Teamcenter Databases

Ask any DBA what the single most important part of their job is and their answer should always be backup/recovery.  The DBA plays a critical role in being able to recover the databases (and overall availability) from a failed state.  Backups can be a tricky thing to define as there can be external pieces that…

0

TechNet Webcast: Best Practices for Deploying Siemens Teamcenter Applications on SQL Server – Lonnye Bower

Our very own Lonnye Bower is giving a TechNet Webcast presentation on Best Practices for Deploying Siemens Teamcenter Applications on SQL Server. Event Overview  Join us for this webcast as we share the best practices for deploying Siemens Teamcenter applications on Microsoft SQL Server 2008 data management software. We talk in detail about performance, high…

0

Scalability – Dassault Systèmes ENOVIA V6 on SQL Server 2008 Benchmarking Datasheet

SQL Server 2008 provides built-in enterprise-class scalability—there is no need to purchase costly add-ons. With SQL Server 2008, you can utilize: Resource Governor to manage SQL Server workload and system resource consumption.  WIth Resource Governor you can specify limits on resources (CPU and memory) that incoming application requests can use.  Resource Govenor is great for…

0

PROS: Oracle to SQL Case Study

Companies must address complex pricing issues, involving increasingly sophisticated trading partners, to improve profitability in business-to-business (B2B) transactions. Successful pricing software needs to deliver meaningful business intelligence to front-line sellers in real time, integrate with existing tools and business processes, and achieve high user adoption rates. To address these challenges PROS integrated its pricing optimization…

0

Change Data Capture – What is it and how do I use it?

In the All Good Things Come to an End – Why You Should Upgrade article we discussed some of the new features that applications can take advantage of by upgrading to SQL Server 2008. CDC (Change Data Capture) was introduced in SQL Server 2008 as a way to capture the data that is inserted, updated, or…

0