|
|
-
|
|
Part of the Performance Tuning series – Performance Stack, this section looks at Storage Tuning. The purpose of the series is a general approach to Performance Tuning – independent of database server platform. A large proportion of DBAs support more than one type of database server and......
|
|
-
|
|
There’s a good article on http://www.ibm.com/developerworks/data/library/techarticle/dm-0807kharche/ outlining the DB2 9.5 process model.
Key Points
New memory model
Increased automatic configurations. According to the article, less is required of the DBA. Based on my experience since D......
|
|
-
|
|
I received the following message from a Developer. The message was on a Test SQL Server.
“NC_myIndex " on table "VeryLargeTable" (specified in the FROM clause) is disabled or resides in a filegroup which is not online.
The cause of the message was that the index was disabled. I discovered th......
|
|
-
|
|
Stress test SQL Server for new hardware.
Download SQLIOSim from http://download.microsoft.com
and install on server.
When detailing the file location, use the same as the SQL Server files. SQLIOSim
will attempt to simulate the SQL Server database IO ......
|
|
-
|
|
Performance testing a new disk subsystem from a SQL Server perspective is one of
the fun aspects of DBA work. Firstly, it’s a great opportunity to influence the
optimizations and give valuable feedback to the storage team. Secondly, it’s difficult
to ......
|
|
-
|
|
Setting HADR_PEER_WINDOW at zero, only blocks primary transactions for the time
specified in HADR_TIMEOUT.
If the HADR_PEER_WINDOW is set to greater than zero, then the Primary database waits
until the connection is restored or the HADR_PEER_WINDOW period......
|
|
-
|
|
The storage guy is configuring a new storage system. It includes RAID arrays, SVC, HBA & Fibre Channel configurations.
He’s asked me to define some configurations for optimal SQL Server performance. Rather than supply him with configurations, I prefer a different approach.
Create a IOPS ......
|
|
-
|
|
Setting up a new database server environment in a new data centre requires testing.
It’s a mix of benchmarking and stress testing. Unless you can recreate the underlying
traffic and recreate a “realistic” production environment, then it’s not stric......
|
|
-
|
|
Assuming the database was detached successfully, this t-sql code will attach a mdf file without a log file. It will also reattach the database with a new database name.
USE [master]
GO
CREATE DATABASE [myTestDatabase] ON
( FILENAME = N'E:\Program Files\Microsoft SQL Server\Data\MSSQL.1\MSSQL\D......
|
|
-
|
|
You’re experiencing a sudden slow down in SQL Server performance. Users are complaining. Many reasons could be causing this sudden slowdown.
For SQL Server performance problems, gathering and analyzing data is not enough. A lot of time can be wasted analyzing data not relevant to the proble......
|
|