|
|
-
|
|
On some installations I see the SQL Server specific performance counters not appearing. This might be caused by a Minimum install or not choosing Performance counters from a custom install
The correct way to rebuild the SQL server specific counters is to run the following command:
lodctr
examp......
|
|
-
|
|
According to SQL Server BOL – the CXPCACKET wait type
“Occurs when trying to synchronize the query processor exchange iterator. You may
consider lowering the degree of parallelism if contention on this wait type becomes
a problem.”
The CXPACKET wait ty......
|
|
-
|
|
There are considerable design considerations for designing redundancy into a SQL Server database system for high availability(HA).
The extent to which redundancy is built into a system will depend on: expertise, cost, resources, service level agreements (SLA)
General areas in considering the HA s......
|
|
-
|
|
SQL server typically implements Level: 0, 1 & 5 RAID levels
RAID 5 – blocks striped & distributed parity. Very widely used strategy and is a variation of RAID 3 (see below).Striping and parity are used – striping is the data placement across multiple drives. Parity is fault to......
|
|
-
|
|
I work with SQL Server and DB2, both have their advantages and disadvantages. But one thing that IBM does more effectively is documentation. SQL Server Books Online is thorough documentation, but the documentation for IBM DB2 is execllent in the way it covers all the details ,in an expansive manner.......
|
|
-
|
|
SQL Server monitors\measures waits by threads. This is a very useful method of focusing on where the real performance issues are occurring. This works for overall performance and also for defined batches
Current Datawarehouse I’m working on is experiencing the following waits. The base inform......
|
|
-
|
|
Transfering a 110 GB file using ESEUTIL– which is a non-buffering tool – I was receiving this error message at 80% transfer of the file
This indicates resource limits are being used. The confusing aspect is that ESEUTIL is a non-buffered approach to copying files, so I was stumped with......
|
|
-
|
|
You’ll get this error message when attempting to restore a database with automatic storage onto a server where the path doesn’t exist.
I had this problem when attempting:
db2 restore db db1 from /db2inst1/backups into db1 redirect without prompting
The error message was
SQL1051N The......
|
|
-
|
|
A login can be granted CONTROL SERVER rights,
USE mater
GO
CREATE LOGIN test WITH PASSWORD = ‘myPassword123’;
GO
GRANT CONTROL SERVER TO test;
CONTROL SERVER rights allows a login to do anything in SQL Server, but there is one subtle difference with sysadmin.
It is possible to exp......
|
|
-
|
|
In architecting a database server system, an important aspect is the assumption of a 24 x 7 database server environment .
The 24 x 7 model is becoming more prevalent – not only in ecommerce, but also in 9-5 businesses – who require access to database servers throughout the 24 hr period......
|
|