|
|
-
|
|
This is my OLTP performance checklist baseline configuration checklist, using DB2 9.1 # 9.5 for OLTP DB2 systems.
For DB2 servers supporting OLTP, I execute a script that gathers this information. Based on application requirements, these configurations can deviate.
The SYSTEM based are dependant o......
|
|
-
|
|
Is there a difference between a Database Architect and Data Architect ? I was talking
with a colleague , who is creating a job description for a Data Architect. As we
discussed the skillset and characteristics of the two roles – it became obvious
there is some overlap &nda......
|
|
-
|
|
SQL Server Version with Powershell and documenting SQL Server versions, is a necessary
timesaving methods. For instance, I'm upgrading loads of sql servers at the moment
and the following script, gives me a quick way of getting a summary of versions.
Place all the relevant serve......
|
|
-
|
|
SQL Kill connections on a database, sometimes is the most efficient way forward.I had to copy a whole bunch of MDF\LDF files from a server , but was experiencing some problems regarding user connections.
I was trying to detach using this code:
#####################code start######################......
|
|
-
|
|
Shared memory set problem on DB2 . Running DB2 V9.5 Enterprise on Linux 32 bit 8GB
Physical memory, and I was getting the following messages:
"Unable to attach 3 segments totalling 679084032 bytes starting at address 0x00000000.
One possible cause may be an improper settin......
|
|
-
|
|
2”
How can this information be used to improve SQL Server performance?
1) Treat the sys.dm_db_missing_index_details as advice, rather than making the
change automatically.
2) Evaluate the advice – and make decisions after testing and within the overall
SQL......
|
|