• blog

    Blog has been migrated to http://www.dassaultonsql.com

    • 0 Comments
    Dear readers - please note that this blog is no longer active at this location. The blog has been migrated and is now available on Technet at the following friendly URL: http://www.dassaultonsql.com . Thank you
  • blog

    The DBCC INDEXDEFRAG Command

    • 0 Comments
    Understanding DBCC (Database Console Commands) is a step toward becoming a better and well-rounded DBA for ENOVIA V6 . In my last post , I covered the basics of DBCC DBREINDEX, a command that rebuilds your indexes to remove fragmentation. In this post...
  • blog

    The DBCC DBREINDEX Command

    • 0 Comments
    If you want to be a better and well-rounded DBA for ENOVIA V6, understanding DBCC (Database Console Commands) is an important step. In my last post , I covered the basics of the DBCC SHOWCONTIG command and how to find table fragmentation. In this post...
  • blog

    The DBCC SHOWCONTIG Command

    • 0 Comments
    If you want to become a better and well-rounded DBA for ENOVIA V6, understanding DBCC (Database Console Commands) is an important step. In my previous posts in this series, I discussed the basics of DBCC and three commands: DBCC SQLPERF, DBCC HELP , and...
  • blog

    SQL Server Scan and Seek Execution Plan Operations

    • 0 Comments
    To get better performance from SQL Server queries, you need to be able to read a query execution plan and determine if that plan needs to be optimized. An execution plan is the method that the optimizer will follow to execute the submitted query, and...
  • blog

    SQL Server Index Intersection/Union

    • 0 Comments
    The SQL Server optimizer has many algorithms and operators to put together reusable execution plans for queries that you run against a system. One is the ability to perform index intersection and/or union, which basically means that it can use multiple...
  • blog

    Backup and Recovery Basics: Part 2, Recovering Your Databases

    • 0 Comments
    In my last post about backup and recovery, I discussed the various methods for backing up a SQL Server database. In this post, I'll discuss the other half of the equation: restoring the database. After all, backups are only as good as the last restoration...
  • blog

    The SQL Server 2008 Data Collector: Part 3

    • 0 Comments
    This is the third post in a series about the data collector in SQL Server 2008. In the first post , we looked at how to set up the data collector; in the second post , we looked at the standard counters that are captured by the data collector. In this...
  • blog

    SQL Server Index Types

    • 0 Comments
    Query optimization is one of the most important skills in your system performance and scalability toolkit, and correct index usage is one of the most effective ways to get good query execution plans. Queries need efficient on-disk access paths to minimize...
  • blog

    The SQL Server 2008 Data Collector: Part 2

    • 0 Comments
    This is the second part in a series of posts about the data collector in SQL Server 2008. In this post, I will list the measurements that are available from the data collector. This may seem like a strange post, but I could not find this information anywhere...
  • blog

    The SQL Server 2008 Data Collector: Part 1

    • 0 Comments
    This is the first part of a series of posts about the data collector in SQL Server 2008. The data collector captures key Windows Performance Monitor counters and internal SQL Server counters every minute in a SQL Server database. In this post, I'll show...
  • blog

    Understanding the Performance Characteristics of Your System: Part 3

    • 0 Comments
    You can learn a lot about performance and potential problem areas by simply watching the CPU usage of your running system over time. As I outlined in the previous posts in this series, after you have validated that there are no errors or deadlocks occurring...
  • blog

    Backup and Recovery Basics

    • 0 Comments
    As database administrators, we are charged with not only protecting our data but also being able to recover it in case of emergencies. For that reason, knowing the different types of backups that are available to you in SQL Server, how they work, and...
  • blog

    Understanding the Performance Characteristics of Your System: Part 2

    • 0 Comments
    Last time, I blogged on the first in a series of steps you need to take to verify your system is not experiencing any system errors or deadlocks. There are just a few more things you need to verify before moving on. Validate the Server Properties Start...
  • blog

    The DBCC CHECKALLOC Command

    • 0 Comments
    Understanding DBCC (Database Console Commands) is a step toward becoming a better and well-rounded DBA for Workforce Central. In my last post , I covered the basics of DBCC and two of its commands: SQLPERF and HELP. In this post, I will cover the DBCC...
  • blog

    Introduction to DBCC Statements

    • 0 Comments
    Understanding DBCC (Database Console Commands) is a step toward becoming a better and well-rounded database administrator (DBA) for Workforce Central. DBCC is a command in Transact-SQL that helps you implement maintenance, validation, and information...
  • blog

    What SQL Server Services Are Necessary for Enovia?

    • 0 Comments
    If you are having performance issues with your SQL Server system, the last thing you need is to have unnecessary services running, consuming resources that you need for productive work. A common issue I've found when I work on sites that are using SQL...
  • blog

    Understanding the Performance Characteristics of Your System: Part 1

    • 0 Comments
    How do you know if you have something out of the ordinary occurring on your database application system if you don't have a good feel for what "ordinary" looks like? Finding the Norm It is difficult to determine if there is a performance bottleneck...
  • blog

    The Plan Cache

    • 0 Comments
    Knowing which queries are performing slowly gives you inside knowledge that you can use to optimize SQL Server. Every query that is executed against SQL Server is stored in the plan cache. Besides the raw query and the execution plan that is needed for...
  • blog

    Are You Making This Common RAM Mistake?

    • 0 Comments
    RAM is the secret sauce in SQL Server performance: the more RAM, the faster the performance. In this post, I'll discuss how RAM is allocated for the data cache in SQL Server. SQL Server fulfills a request for data only from RAM, never streaming off the...
  • blog

    Updating a SQL Server Failover Cluster

    • 0 Comments
    You have your highly available instance of SQL Server in place, and you've grown comfortable with the unique attributes of administering a clustered SQL Server configuration. (See my previous post .) Now, you've decided (or Dassault Systèmes has asked...
  • blog

    Managing a SQL Server Failover Cluster

    • 0 Comments
    SQL Server failover clustering can be intimidating if you're not used to administering clustered systems. In my earlier post , I discussed how to install Windows and SQL Server in a failover cluster configuration. ENOVIA V6 fully supports using a clustered...
  • blog

    Installing SQL Server Failover Clustering

    • 0 Comments
    SQL Server has a variety of options to improve availability, including failover clustering. Failover clustering protects you from several kinds of hardware and software failures, such as a server crash, a local disk drive failure, or an application fault...
  • blog

    Performance Analysis of Logs (PAL) Tool: Part 3

    • 0 Comments
    The PAL tool can help you find performance bottlenecks in SQL Server running ENOVIA V6 by aggregating and evaluating the hundreds of Windows Performance Monitor counters that are associated with SQL Server. In part 1 and part 2 of this series about the...
  • blog

    Performance Analysis of Logs (PAL) Tool: Part 2

    • 0 Comments
    Do you want to improve the performance of ENOVIA V6 on SQL Server by finding and clearing the bottlenecks? Then fire up the PAL tool. This tool can help you find performance bottlenecks in SQL Server running ENOVIA V6 by aggregating and evaluating the...
Page 1 of 3 (66 items) 123