Sign in
|
Help
Home
Blogs
Media
All Tags
»
SQL Server
»
i/o
(
RSS
)
Recent Posts
SQL Server database design goals: Memory, Disk and I/O - maximize the scalability with monitoring
SQL Server Deadlock and Trace Flag 1204 and 1222- a big question every time
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
SQL Server 2005 and Disk drive allocation unit size to 64K - any benefit or performance?
SQL Server databases - checkpoint, cache and I/O request - what you need to know?
Tags
.NET
Advisories / Bulletins
ASP.NET
C#
Community
Digital Media
Exchange
General
General Security News
Media Center
Microsoft
News
OpsMgr 2007
Rants
Security
Sharepoint
SPPS03_Tips
SQL Server
System Center
Tools
VB
Vista
Windows 7
Windows OS
Windows Server
Browse Blog Posts by Tags
Showing related tags and posts for the
Blogs
application. See
all tags in the site
2008
activity
allocation
article
backup
bcp
beginner
best practice
best practices
binaries
blogs
bulk insert
bulk-logged
cache
capacity
capture
checklist
checkpointl
cluster
clustered
configuration
connect
contention
cpu
data
database
databases
dba
deadlock
defragmentation
delete
deployment
destination
development
disk
disk space
disks
dmv
extent
feedback
file
flush
fragmentation
hcl
import
indexes
input
insert
kba
layout
locking
maintenance plan
management
memory
microsoft
monitoring
msdn
object
perflib
performance
performance monitoring
raid
replication
resource
resource governor
resources
san
search
security
server
services
setup
source
sp2
sp4
sql express
statement
statistics
storage
sysmon
table
task manager
technet
throughput
tools
transaction log
tsql
tuning
type
update
usage
vendor
wait
windows
worker threads
SQL Server database design goals: Memory, Disk and I/O - maximize the scalability with monitoring
Do you consider the I/O whenever a database design project is assigned? It is one of the primary design goals of all database software is to minimize disk I/O because disk reads and writes are among the most resource-intensive operations. Over the time...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Fri, Aug 21 2009
Filed under:
Filed under:
sql server
,
performance
,
memory
,
tools
,
i/o
,
disk
,
statistics
,
monitoring
,
capacity
,
input
SQL Server Deadlock and Trace Flag 1204 and 1222- a big question every time
I have seen few users out there thinks that Deadlocks in SQL Server is a bug which has not be corrected by Microsoft since its release! Even few times they get think that deadlocks and blocking are similar reactions in SQL Server, a typical situation...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Tue, Mar 17 2009
Filed under:
Filed under:
sql server
,
performance
,
indexes
,
i/o
,
best practices
,
locking
,
deadlock
,
monitoring
,
beginner
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
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Tue, May 13 2008
Filed under:
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?
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Mon, Apr 28 2008
Filed under:
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?
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Tue, Apr 22 2008
Filed under:
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?
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Fri, Apr 4 2008
Filed under:
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
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Thu, Mar 27 2008
Filed under:
Filed under:
sql server
,
backup
,
services
,
windows
,
i/o
,
best practices
,
cluster
,
san
,
raid
,
setup
,
hcl
,
binaries
,
checklist
SQL Server 2008 Resource Governor FAQ
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Mon, Feb 25 2008
Filed under:
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?
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Tue, Jan 29 2008
Filed under:
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?
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Thu, Jan 10 2008
Filed under:
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
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Fri, Jan 4 2008
Filed under:
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
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Mon, Sep 17 2007
Filed under:
Filed under:
sql server
,
performance
,
microsoft
,
security
,
i/o
,
storage
,
throughput
,
vendor
DBCC EXTENTINFO - unused pages in these extents (undocumented)
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Tue, Sep 4 2007
Filed under:
Filed under:
sql server
,
performance
,
indexes
,
data
,
i/o
,
table
,
insert
,
allocation
,
fragmentation
,
deadlock
,
extent
ASYNC_NETWORK_IO: query is slow
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Wed, Aug 29 2007
Filed under:
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
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Tue, Aug 28 2007
Filed under:
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
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Sun, Aug 5 2007
Filed under:
Filed under:
sql server
,
performance
,
dmv
,
cache
,
i/o
,
cpu
SQL Server 2005 Service pack 2 re-release & too many builds
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Tue, May 15 2007
Filed under:
Filed under:
sql server
,
security
,
server
,
search
,
replication
,
sp2
,
i/o
Page 1 of 1 (17 items)