|
|
-
|
|
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......
|
|
-
|
|
Choosing the optimal amount of disks for a RAID server configuration and block sizes can be a challenge.
Typical questions from the SAN\Storage guy to the DBA are:
“How many disks in a RAID configuration?”
“What is the optimal block size?”
“What MB\sec throughput?&......
|
|
-
|
|
A couple of years ago, I heard some new terms: “10x developer” and “2x developer”.
A 10x developer seemed to complete tasks almost instantly. A 2x developer took a
long time to complete a task. These terms can also be applied to other jobs such
......
|
|