|
|
-
|
|
I suggested to a client last week ,Query Tuning is required to troubleshoot some SQL performance issues. He wanted a definition of Query Tuning. I sent him an email,
defining a Query Tuning approach .These are notes from the email
What is Query tuning?
In practise, there are predeployment qu......
|
|
-
|
|
Reorg table DB2
Step 1
run reorgchk:
------CODE START---------------
db2 reorgchk update statistics on table all > output.out
------CODE END------------------</b>
Running the command this way will run across all tables rather than RUNSTATS across every table.
The reorgchk update statistics r......
|
|
-
|
|
DBA is a demanding job. Expertise is required at different levels – hardware, OS , Database Server and Application Layer. As pressure increases to give input at an operations and architecture level, remember the two primary tasks of the DBA is to maintain availability and performance.
These a......
|
|
-
|
|
Windows Server Uptime and the last time a Windows Server restarted, on a database server is useful information. As well as SQL Server I do also manage some DB2 Server on Windows - which has different information available for server level information. Net Statistics Server displays the details.......
|
|
-
|
|
Powershell for SQL SMO has fantastic potential. Robert Matthew Cook left me some code on SQL Server xp_msver - seeing if I was interested on expanding.
The Server Object offers SQL Server Instance Information
[Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | Out-Null
$S......
|
|
-
|
|
Windows Perfmon and SQL Server perfmon is critical to any migration project. Test before and test after, also known as baselining, provides a great way to review and analyse server performance issues.
Standardised capture of Windows perfmon data is one of the requirements for data migration proje......
|
|
-
|
|
To many databases per instance.
There is no ideal number of databases per instance. Indicators are:
a)Bufferpol thrashed. For example, large table scans can cause buffer pool thrashing
b)Large amount of lazy writing – the SQL Server lazy writer maintains free buffers......
|
|
-
|
|
Powershell and SQL Server is a great mix for Disaster Recovery planning. There are many aspects to database server disaster recovery planning – including: backup storage and location,
rebuild documentation, installation media, rebuild scripts, DNS and cnames, escalation process and securit......
|
|
-
|
|
Adding an extra SQL server transaction log file will not improve throughput performance.
SQL Server Transaction Log files are written as sequential for a database.
SQL Server uses one transaction log file at a time – no matter how many log files are assigned to a database.
I have seen ......
|
|
-
|
|
SQL Server Database Status and monitoring sometimes return false negatives. The
monitoring should reflect planned Database Status changes – such as ETL processes
and SQL Server Restores, consider adding a parameter to include the Database Status.
Let me explain.
Cur......
|
|