Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Articles & Samples > SQL Server > Performance Tuning


Search:
What's New - What's Hot
Using PowerShell to Manage SQLServer  Version: 0.00     Price: $0.00  
Total Hits: 8  |  Today: 0Author: Fabiano Pereira      Rating:  
Read Reviews | Write Review |  Your Rating: 

The purpose of this article is to demonstrate a custom scripting framework which enables the management of SQLServer databases from a Windows PowerShell session and also to extend Powershell's flexibility by creating a set of commands customized to our needs. I will call this framework comprised of a library of modules and functions specialized to manage SQLServer the DBA profile....

How to Do SQL Server Performance Trend Analysis Part 3: Storing Performance Data in SQL Server  Version: 0.00     Price: $0.00  
Total Hits: 16  |  Today: 0Author: Brad McGehee      Rating:  
Read Reviews | Write Review |  Your Rating: 

This is part three of a four-part tutorial. This part discusses how to use Microsoft Excel to create analysis charts and how to perform trend analysis using Performance Monitor data. Part four will show you how to interpret your results. Read part one. Read part two....

Transferencia de las Estadísticas de SQL Server de una Base de Datos a otra  Version: 0.00     Price: $0.00  
Total Hits: 8  |  Today: 0Author: Luis Martin      Rating:  
Read Reviews | Write Review |  Your Rating: 

Nota del traductor: Algunas palabras se han mantenido en inglés por no disponer en castellano de una traducción apropiada, en el lenguaje computacional. Esas palabras son las siguientes con su traducción literal en algunas de ellas y con un pseudo castellano en otras....

Operating System Performance Optimization  Version: 0.00     Price: $0.00  
Total Hits: 11  |  Today: 0Author: Brad McGehee      Rating:  
Read Reviews | Write Review |  Your Rating: 

The focus of this section of our performance audit is the base operating system, and how to optimize it in order to get the best performance out of SQL Server.

Like SQL Server, Windows Server is mostly self-tuning. But like SQL Server, there are things we can do to help optimize Windows' performance. And every time we help boost the performance of Windows Server, we are at the same time boosting the performance of SQL Server....

SQL Server Performance: Query Tuning vs. Process Tuning  Version: 0.00     Price: $0.00  
Total Hits: 14  |  Today: 0Author: Nils Bevaart      Rating:  
Read Reviews | Write Review |  Your Rating: 

In the different projects where I perform a performance audit or am involved in performance tuning, I often find that while queries and stored procedures function correctly, they are not efficient in processing larger data sets. Many OLTP databases are set up as OLAP databases to handle single records instead of a record set as a whole....

Check List for Performance Optimisation in SQL Server Analysis Service 2005  Version: 0.00     Price: $0.00  
Total Hits: 4  |  Today: 0Author: Dinesh Asanka      Rating:  
Read Reviews | Write Review |  Your Rating: 

No matter what your platform or the tools that you are using, performance is almost always the number one feature that customers require. In the case of SQL Server Analysis Service (SSAS), there are four areas where we can improve the performance. They are database design, processing, querying and configuring SSAS....

Schema Comparison with Visual Studio Team Edition for Database Professionals  Version: 0.00     Price: $0.00  
Total Hits: 14  |  Today: 0Author: Dinesh Priyankara      Rating:  
Read Reviews | Write Review |  Your Rating: 

Most DBAs work with different environments such as production, quality assurance and development where the same database schema exists. One of the biggest issues we have been facing while maintaining the same database schema in various environments is making sure that the objects exist in the databases are the same in all environments and if not, finding the differences and applying them to the relevant environments. How you have been doing this? Did you do it manually (imagine doing it manually...

Security Manager - Full Control of MySQL Users and Their Privileges  Version: 0.00     Price: $0.00  
Total Hits: 22  |  Today: 0Author: docsmaker      Rating:  
Read Reviews | Write Review |  Your Rating: 

Efficient database administration depends on many factors. Security is a key point that guarantees stability of both a separate database and a large database infrastructure.

Correct and accurate administration of user accounts and their privileges greatly contributes to security. However, it turns to be a tough task in practice. DB administrators know that in fast-paced environment it's impossible to avoid errors, while controlling a huge amount of accounts and their privileges, unless yo...

SQL Server for Network Administrators     
Total Hits: 122  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

My job function is a Network Administrator, not a SQL Server DBA or Developer, but I work with SQL Server on a regular basis. I could use some pointers to improve my skills. What would be a good SQL Server primer for me? What are some high level SQL Server topics that I should be aware of for my regular tasks? Where can I get some additional information to brush up on my skills?...

Kill SQL Server Process Ids (spids)     
Total Hits: 191  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

I have noticed some of my processes are failing because spids are already connected to the database. This happens specifically when I need to a restore database. I catch this problem pretty quick when I am working on it during the data and can fix it, but during nightly processing existing spids become problematic. I have also noticed existing spids causing problems for my SQL Server 2000 Database Maintenance Plans....

Performance Optimizations for the XML Data Type in SQL Server 2005     
Total Hits: 128  |  Today: 0Author: Shankar Pal, Babu Krishnaswamy, Vasili Zolotov, an      Rating:  
Read Reviews | Write Review |  Your Rating: 

This paper explores several ideas to improve the query and data modification performance of the XML data type in Microsoft SQL Server 2005. To get the most value from this paper, you need to be familiar with the XML features in SQL Server 2005. For background material, see XML Support in Microsoft SQL Server 2005 and XML Best Practices for Microsoft SQL Server 2005 on the Microsoft Development Network (MSDN)....

Introduction to New Data Warehouse Scalability Features in SQL Server 2008     
Total Hits: 109  |  Today: 0Author: Eric N. Hanson, Kevin Farlee, Stefano Stefani, Shu      Rating:  
Read Reviews | Write Review |  Your 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...

3 Tips for Customizing MySQL Enterprise to Achieve Monitoring Best Practices     
Total Hits: 51  |  Today: 0Author: Rob Young      Rating:  
Read Reviews | Write Review |  Your Rating: 

During my years as a Developer/DBA hearing the words "customizable" or "extensible" always brought a slight smile to my face, particularly when they were used in conjunction with a software sales pitch or evaluation. In fact, more often than not, while presented as product features, these words often really mean, "you can do some additional things with this software if you are willing to invest significant time and resources into doing so". Even today, some of the most popular open source and co...

Integrating Analysis Services with Reporting Services     
Total Hits: 87  |  Today: 0Author: Sean Boon      Rating:  
Read Reviews | Write Review |  Your Rating: 

Create a compelling solution for your customer that defines and manages great-looking Analysis Services reports, and quickly answers analytical questions to improve traditional reporting scenarios.
There are many features of Reporting Services that can be beneficial to Analysis Services customers. These features include centralized report storage and management, control over how reports are processed or administered, and the ability to quickly change report formats (HTML, Excel, PDF, etc.). W...

What the IT Decision-Maker Needs to Know About SQL Server Performance Tuning     
Total Hits: 323  |  Today: 0Author: Kurt Survance      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article is written for someone with a working knowledge of information technology, but with little specific SQL Server expertise. The typical reader would be an IT manager or executive who needs background information to properly evaluate all the performance tuning suggestions being offered to him/her before spending significant amounts of money on performance tuning....

High Call Volume SQL Server Applications on NUMA Systems     
Total Hits: 301  |  Today: 0Author: Joe Chang      Rating:  
Read Reviews | Write Review |  Your Rating: 

One of the most difficult database operations to scale-up on high-end server systems is the network call. In fact, without special precautions, a high call volume database application can have severe negative scaling on large systems. It is suspected that this problem is more pronounced on NUMA systems than basic SMP systems. A NUMA system with 16 processors can have significantly lower throughput capability than an otherwise comparable 4-way SMP system. Many SQL Server performance experts have ...

Eliminate the Use of Temporary Tables For HUGE Performance Gain     
Total Hits: 265  |  Today: 0Author: Justin Gunther      Rating:  
Read Reviews | Write Review |  Your 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....

How to Perform a SQL Server Performance Audit      
Total Hits: 687  |  Today: 0Author: Brad M. McGehee      Rating:  
Read Reviews | Write Review |  Your 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....

SQL Server Performance Audit     
Total Hits: 640  |  Today: 0Author: Brad McGehee      Rating:  
Read Reviews | Write Review |  Your Rating: 

Learn how to do a performance audit of SQL Server in order to get the best overall performance for your ASP applications...

SQL Server Integration Services (SSIS) – Part 2 – Transforming SQL Data to Excel Sheet  Version: 0.00     Price: $0.00  
Total Hits: 6  |  Today: 0Author: Karthikanbarasan      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article we will see how data can be transferred from SQL Server DB to Excel sheet. Refer to my previous article (Part 1) on the basics of SSIS and steps to create the first SSIS package at the below url...


1  2  3  4  5  6  7  8  9  10  Next >> 


Disclaimer - Privacy
© 2002-2017 DevASP.net