Browse by Tags

KBA - UPDATE Statements May be Replicated as DELETE/INSERT Pairs & Diagnostics in SQL Server 2000 SP4 and in later versions help detect stalled and stuck I/O operations

Published 13 May 8 1:45 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications UPDATE Statements May be Replicated as DELETE...

Filed under: sql server, update, i/o, kba, insert, delete, statement, sp4

SQL Server 2005 and Disk drive allocation unit size to 64K - any benefit or performance?

Published 28 April 8 3:1 AM | SSQA.net

You may be aware that or seen within your Database platform about slower disk performance than expect having multiple disks in Windows Server 2003 environment when you use a hardware-based redundant array of independent disks (RAID) or a software-based...

Filed under: sql server, performance, microsoft, technet, i/o, article, disk, best practices, monitoring, deployment, layout

SQL Server databases - checkpoint, cache and I/O request - what you need to know?

Published 22 April 8 1:51 PM | SSQA.net

Have you ever wondered about flushing databases? Well not quite possible to flush it straight away and not a best practice too on the live server, so what it is about and you need to know about transactions state when they occur. Say when the changes...

Filed under: sql server, performance, msdn, backup, blogs, database, transaction log, cache, i/o, flush, monitoring, checkpointl

SQL Server 2005 Scalability and Performance - recommended limit on number of instances on a clustered environment?

Published 4 April 8 4:48 AM | SSQA.net

This is a very tricky question and hard to stick to 1 or few solutions as answer, it depends! Overall the say is if there isn’t any resource contention (from your pre-installation testing & analysis) and there is enough of each resource to go around...

Filed under: sql server, memory, maintenance plan, i/o, clustered, best practice, monitoring, resources, configuration, performance monitoring, contention

SQL Server Clustering get pre-installation information and choose the best practices for your environment

Published 27 March 8 3:40 AM | SSQA.net

Before installing the SQL Server cluster there must be a checklist in order to ensure you haven't compromised on any hardcore requirement. In this regard Microsoft suggests the hardward that must be listed on this Windows Catalog and Hardware Compatibility...

Filed under: sql server, backup, services, windows, i/o, best practices, cluster, san, raid, setup, hcl, binaries, checklist

SQL Server 2008 Resource Governor FAQ

Published 25 February 8 1:36 AM | SSQA.net

Bottlenecks aka locking & blocking is a quite common scenario within a RDBMS platform, that too SQL Server is not an exception at all. With an access to shared resources causes bottlenecks and demands on shared resources cause poor response time and...

Filed under: sql server, performance, memory, dba, i/o, disk, 2008, development, cpu, best practice, capture, resource governor

How SQL Server manages when a database is created in terms of I/O and disk usage?

Published 29 January 8 5:46 AM | SSQA.net

One of the best features you have in the SQL Server is to create database data file (additional) on fly without having a slow performance affect on existing connections. But think about how SQL Server manages to use server threads for the data file that...

Filed under: sql server, performance, management, indexes, windows, i/o, sysmon, disk space, usage, resource, perflib, worker threads, task manager

How to monitor transaction activity between the databases?

Published 10 January 8 4:23 AM | SSQA.net

Recently I have been through interesting forum post on SQL Server performance website that a user asking how to monitor transaction activity between the databases without using a third party tool. Until SQL 2000 version it is not that easy to get more...

Filed under: sql server, databases, dmv, i/o, tsql, statistics, activity

Vote now: Index defragmentation best practices for SQL Server 2005 documentation - feedback received from Microsoft

Published 4 January 8 5:35 PM | SSQA.net

May 25 2007- From the snippet of Tibor Karaszi , SQL Server MVP I have raised a feedback form on Connect.Microsoft website to get newer version (SQL Server 2005) about Index Defragmentation Best practices information. Vote your interest to get newer documentation...

Filed under: defragmentation, sql server, indexes, microsoft, i/o, best practices, feedback, sql express, connect

Determining the required capacity of an I/O subsystem before deploying the database

Published 17 September 7 8:49 AM | SSQA.net

It is a good practice to determine the required capacity for a database application before it is deployed on the Production environment. As it speaks the I/O system is "most" important to the performance of SQL Server, in the event of any performance...

Filed under: sql server, performance, microsoft, security, i/o, storage, throughput, vendor

DBCC EXTENTINFO - unused pages in these extents (undocumented)

Published 4 September 7 7:45 AM | SSQA.net

When it comes to resolving table fragmentation, the basic checkout you perform is to run DBCC INDEXDEFRAG or even run DBCC DBREINDEX statements. As per the default configuraiton SQL Database Engine allocates a new extent to an allocation unit only when...

Filed under: sql server, performance, indexes, data, i/o, table, insert, allocation, fragmentation, deadlock, extent

ASYNC_NETWORK_IO: query is slow

Published 29 August 7 5:0 AM | SSQA.net

When you run normal SELECT statement from the Activity Monitor, the session has a status of "suspended", a command of "SELECT" and a wait type of "ASYNC_NETWORK_IO". What do you expect to the see the results and within the...

Filed under: sql server, performance, tuning, i/o, object, disks, type, wait

Error = [Microsoft][ODBC SQL Server Driver]Unexpected EOF encountered in BCP data-file

Published 28 August 7 10:10 AM | SSQA.net

When you use BCP then you would definelty get to see this error "Unexpected EOF encountered in BCP data-file". Not only that I have seen this as one of the frequently asked questions (FAQs) and for a moment you might be thinking why there is...

Filed under: sql server, i/o, import, file, bulk-logged, destination, bulk insert, source, bcp

List of CPU based DMVs in SQL Server 2005 - best used for hardware analysis

Published 5 August 7 2:32 PM | SSQA.net

Dynamic Management Views (DMV) are very useful to get server state information to monitor the status, but not always you have to still continue in monitoring using SYSMON & PROFILER that are available by default with SQL installation. The engine within...

Filed under: sql server, performance, dmv, cache, i/o, cpu

SQL Server 2005 Service pack 2 re-release & too many builds

Published 15 May 7 3:17 AM | SqlServer-QA.net (SSQA)

I feel like there is lot of confusion ( new users ) in deciding which build to apply after the re-release of SQL Server 2005 Service Pack2 during the month of March 2007. So here is the list of references I would like to share in explaining what is what...

Filed under: sql server, security, server, search, replication, sp2, i/o