|
|
|
|
|
|
| | Total Hits: 138 | Today: 0 | Author: Edgewood Solutions Engineers | Rating:  |
| | 
One of the biggest things that DBAs try to do on a daily basis is to ensure that their database systems run as fast as possible. As more and more users access the databases and the databases continue to grow, performance slow downs are almost inevitable. Based on this, DBAs and developers should do everything they possibly can to keep performance related issues in mind early in the database lifecycle. This is not always easy to do, because of the unknowns and the changes that occur over time, ... |
| | Total Hits: 157 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
Both SQL Server and Windows offer a lot of data to help troubleshoot and monitor overall usage and performance for your SQL Server databases. Within SQL Server there are several DBCC commands as well as a lot newly exposed data from the Dynamic Management Views in SQL Server 2005. One way of monitoring your individual database usage is to view the data from the dbo.sysprocesses table or sys.sysprocesses in SQL 2005. This data is also exposed by either using the GUI tools or by running sp_who2.... |
| | Total Hits: 223 | Today: 0 | Author: Enrique Garcia | Rating:  |
| |
You get a call from tech support that users are complaining about a report being particularly slow. Tech support says they think the problem occurs when retrieving data from the database. After using SQL Profiler to find out what is happening, you find out that the stored procedure that pulls the data for the report is having very high reads and it is taking several seconds to complete. However, when you execute this procedure on the same database to analyze the query plan and start solving the ... |
| | Total Hits: 173 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
Being able to identify SQL Server performance issues at the drop of a hat is easier said than done. Without a means to collect and analyze the performance data it is difficult at best to understand and correct the items in a timely manner. SQL Server ships with a handful of tools to include Profiler, Sysmon\Perfmon and the Database Engine Tuning Advisor\Index Tuning Wizard. Much of the time these tools meet the needs for manual collection and analysis, but what if you need to go beyond the too... |
| | Total Hits: 152 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
When troubleshooting a SQL Server performance problem, one of the tools to use is Profiler. This tool allows you to collect metrics on statements that are run on your SQL Server for analysis and troubleshooting. The problem with using Profiler is that it is a client tool and unless it is run on the server itself the connection may be lost and your trace stops. This usually happens right before the problem your trying to troubleshoot occurs and you don't end up collecting that valuable informat... |
| | Total Hits: 169 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
Just about all SQL Server performance related tips talk about using data from Performance Monitor and data from SQL Profiler. The big draw back has always been that they are two totally separate tools, with different interfaces and therefore you need to figure out a way to correlate the data between the two applications on your own. This was the old way of doing things, but with SQL Server Profiler for SQL 2005 this has changed.... |
| | Total Hits: 183 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
I am concerned our database design is overly denormalized. I believe we have some very wide tables which makes some of our coding very easy, but I am concerned about the data access and overall performance. Before I go too far down the path of just changing some of these tables or trying to change the ways of my team for future database design, how can I find out how wide some of these tables really are based on the data as compared to the theoretical maximum size? Can you provide a script or... |
| | Total Hits: 121 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
One nice feature of SQL Server that is used quite a bit is the use of identity columns. This function gives you a simple way of creating a unique value for every row in your table. Adding a new column and making it an identity column is an easy thing to do as well as dropping an existing column that is an identity column, but how can you modify an existing column to make it an identity column or remove the identity property from an existing column?... |
| | Total Hits: 172 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
SQL Server offers many handy functions that can be used either in your SELECT clause or in your WHERE clause. For the most part these functions provide complex coding that would be very difficult to get this same functionality without these functions. In addition to the built in functions you also have the ability to develop your own user defined functions. When functions are used in the SELECT clause to return uppercase output, a substring or whatever, it doesn't affect performance that much... |
| | Total Hits: 123 | Today: 0 | Author: Brian Noyes | Rating:  |
| |
SQL Server 2005 Compact Edition (SSCE) provides a powerful yet lightweight data storage engine for building a variety of application types. This paper introduces data storage concerns for client applications and small-scale server applications. It discusses the feature set of SSCE and how that feature set addresses data storage concerns. It covers different application architectures where SSCE might be a good fit, highlighting the attributes of the application types and how SSCE can meet the req... |
| | Total Hits: 95 | Today: 0 | Author: Eric N. Hanson, Kevin Farlee, Stefano Stefani, Shu | Rating: |
| |
With the 2008 release, SQL Server makes a major advance in scalability for data warehousing. It meets the data warehouse needs of the largest enterprises more easily than ever. SQL Server 2008 provides a range of integrated products that enable you to build your data warehouse, and query and analyze its data. These include the SQL Server relational database system, Analysis Services, Integration Services, and Reporting Services. This paper introduces the new performance and manageability feature... |
| | Total Hits: 55 | Today: 0 | Author: Narayana Vyas Kondreddi | Rating: |
| |
In this article, I'll share with you, how the SERIALIZABLE transaction isolation level enforced by COM+ effected the performance of an application. At the end of this article I provided links to SQL Server performance tuning books for your reference.
Recently I was asked to improve the performance of an application, that was about to go into production. It was suffering from performance issues. Testers were not very happy with the performance of the application and sometimes the application f... |
| | Total Hits: 72 | Today: 0 | Author: Narayana Vyas Kondreddi | Rating: |
| |
It is always better to be proactive than reactive, when it comes to identifying and eliminating SQL Server performance issues. In this article, I am going to explain the method I follow, to identify performance issues in my database applications, before those applications go into production environment.
Once the application is completely built and tested, I will conduct something called a "Load test" or "Stress test". There are several ways (or tools) in which one can stress test a database a... |
| | Total Hits: 267 | Today: 0 | Author: Peter A. Bromberg | Rating: |
| |
I must confess that this little venture into the ADO.NET 2.0 SqlBulkCopy class had an ulterior motive: Where I work, as with many other places, bosses tend to be reluctant to adopt new technologies early. Now I don't consider Visual Studio.NET 2005 and ADO.NET 2.0 "new technology", but they certainly have the right to be cautious.... |
| | Total Hits: 223 | Today: 0 | Author: Brian Kelley | Rating: |
| |
One of the biggest performance gains built into SQL Server is the stored procedure. SQL Server has the ability to cache the execution plan for re-use at a later time. While SQL Server 2000 has improved tremendously in caching execution plans for ad-hoc SQL queries, it still handles stored procedures best because they happen to be database objects that can be referred to definitively. However, improper techniques in building stored procedures can cause these cached execution plans to be missed ... |
| | Total Hits: 233 | Today: 0 | Author: Justin Gunther | Rating:  |
| |
As queries become more complex, temporary tables are used more and more. While temporary table may sometimes be unavoidable, they can often be sidestepped by using derived tables instead. In brief, a derived table is the result of using another SELECT statement in the FROM clause of a SELECT statement. By using derived tables instead of temporary tables, we can boost our application's performance.... |
| | Total Hits: 652 | Today: 0 | Author: Brad M. McGehee | Rating: |
| |
Quantitative models for the SQL Server internal query cost formulas and the true measured query costs for basic SQL operations are presented. The internal cost formulas are used by SQL Server's Query Optimizer to determine the execution plan based on existing indexes and statistical information on the distribution of data.... |
| | Total Hits: 610 | Today: 0 | Author: Brad McGehee | Rating: |
| |
Learn how to do a performance audit of SQL Server in order to get the best overall performance for your ASP applications... |
| | Total Hits: 246 | Today: 0 | | Rating:  |
| |
This procedure will Analyze & Estimate Statistics for all tables in the users schema. Only takes 3-10 minutes to run. It can easily be edited to Compute Statistics or specific number of rows in each table.... |
| | Total Hits: 495 | Today: 0 | | Rating: |
| |
Using Solid State Accelerators (memory) can be an effective way to boost SQL Server I/O performance.... |
|
|
|
|
|
|