April 2008 - Posts

0
Comments

Customize Black Block Trace by Kasim.Wirama

Customize Black Block Trace By : Kasim Wirama, MCDBA SQL Server has background running trace by default that records some events. It is useful when your SQL Server or its hosting environment had crashed, so you can look some queries and investigate them...
Filed under:
1
Comments

Detecting Blocking Problem by Kasim.Wirama

Detecting Blocking Problem Detecting Blocking Problem By : Kasim Wirama, MCDBA SQL Server uses locks as ACID implementation. Locks ensure data consistency in multiuser environment in database. Locks become issue when several processes waiting for a resource...
Filed under:
7
Comments

Detect Memory Bottleneck in SQL Server by Kasim.Wirama

Detect Memory Bottleneck in SQL Server By : Kasim Wirama, MCDBA This article, I would like to give information about memory bottleneck at SQL Server. The easiest way to know whether your SQL Server undergoes memory bottleneck is by looking at Task Manager...
Filed under:
0
Comments

Detecting and Resolving I/O Bottleneck by Kasim.Wirama

Detecting and Resolving I/O Bottleneck By : Kasim Wirama, MCDBA I/O subsystem is one of critical component in SQL Server. I/O subsystem is used when SQL Server moves page between memory and I/O subsystem. With intensive activity of DML and DDL, SQL Server...
Filed under:
1
Comments

Detect CPU Bottleneck in SQL Server by Kasim.Wirama

Detect CPU Bottleneck in SQL Server By : Kasim Wirama, MCDBA When you have your database server experiencing a problem, there are many possibilities here, such as CPU, memory, hard disk or database configuration itself. There should be a systematic way...
Filed under:
1
Comments

Statistics time for Plan Reuse by Kasim.Wirama

Statistics time for Plan Reuse By : Kasim Wirama, MCDBA In my early days of query tuning during my IT career, I seldom used STATISTICS TIME for query tuning. But recently I just know that statistics time indeed gives useful information. This time statistics...
Filed under:
0
Comments

Read Ahead Read and Scan Count by Kasim.Wirama

Read Ahead Read and Scan Count By : Kasim Wirama, MCDBA If you turn STATISTICS IO on to get know access to underlying tables in a query, you have information logical read, physical read, read ahead read and scan count. Besides logical read and physical...
Filed under:
4
Comments

Logical and Physical Read in SQL Server Performance by Kasim.Wirama

Logical and Physical Read in SQL Server Performance By : Kasim Wirama, MCDBA Every query has its execution plan before it gets executed. Execution plan is generated by optimizer, one of components in SQL Server database engine; it contains how to access...
Filed under:
0
Comments

Access Method in Index by Kasim.Wirama

Access Method in Index By : Kasim Wirama, MCDBA Every query has its execution plan. You can usually find these operators in execution plan, i.e. table scan, clustered index scan/seek, non clustered index seek. I would describe how they combined with table...
Filed under:
4
Comments

Spot Area where Index Could be Potentially Used in a Query by Kasim.Wirama

Spot Area where Index Could be Potentially Used in a Query By : Kasim Wirama, MCDBA This article talks about where you need to implement index in a query. Index is used for fast retrieval of row(s). It looks good but it has overhead, the overhead lies...
Filed under:
1
Comments

Multiple Sessions One Transaction by Kasim.Wirama

Multiple Sessions One Transaction By : Kasim Wirama, MCDBA SQL Server is enterprise level database with multiple connections. When some of those connections have transaction, they have their own transaction id. SQL Server 2005 lets you see the transactions...
Filed under:
0
Comments

SQL Server 2008 Features by Kasim.Wirama

SQL Server 2008 Features By : Kasim Wirama, MCDBA SQL Server 2008 February CTP has a bunch of features that I have to be familiar with their use. Here I note some topic in SQL Server 2008 February CTP: Business Intelligence Datetime series ARIMA algorithm...
Filed under:
3
Comments

Data Modelling by Kasim.Wirama

Data Modelling By : Kasim Wirama, MCDBA One of database discipline that I think the basic of database design is data modelling. Data modelling covers requirement gathering until logical design. The purpose of data modelling is to minimize impact change...
Filed under:
0
Comments

Key and Covered Column in SQL Server Indexes by Kasim.Wirama

Key and Covered Column in SQL Server Indexes Key and Covered Column in SQL Server Indexes By : Kasim Wirama, MCDBA I would share here about index knowledge in SQL Server. Well tuned index will contribute superior database performance besides other factors...
Filed under:
0
Comments

Scan and Seek in Table/Index Structure by Kasim.Wirama

Scan and Seek in Table/Index Structure Scan and Seek in Table/Index Structure By : Kasim Wirama, MCDBA In my articles about query execution plan, I have mentioned that seek operator is better than scan operator in many cases. Table and index structure...
Filed under:
More Posts Next page »
Copyright © INDC, 2006. All rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems