|
|
-
|
|
This morning I found this error message in the TSM schedule logs
ANS1315W (RC15) Unexpected retry request. The server found an error while writing the data.
Preceded by
Waiting for TSM server
The conclusion was there were insufficient mount points or scratch tapes were not available
I......
|
|
-
|
|
Granting execute rights to all stored procedures used to be a cumbersome problem up to before SQL Server 2005. You either had to give elevated rights to the user or run a script to GRANT EXECUTE on every stored procedure.
I still see plenty of databases where a DBA has granted db_owner rights, sim......
|
|
-
|
|
This useful DMV Sys.dm_os_memory_clerks produces a recordset of SQL Server memory clerks currently active. Being aware of memory pressure is critical to managing SQL Server performance. I use this DMV as part of a suite of queries which track external memory pressure and VAS pressure e.g caused by O......
|
|
-
|
|
OK, a member of the application team rushes towards me and says “the database server is slow due to blocking” or “everything has gone really slow” etc. As a DBA ,I’m quite often beset upon by application owners – and answers are needed quickly.
One tool at my di......
|
|
-
|
|
It is important to differentiate between Waits and Queues, when applying the Waits and Queues performance analysis methodology. Even though they are two sides of the same problem, they are approaching resource usage in a different manner.
Waits, refers to any time spent waiting on resources by any......
|
|
-
|
|
--Recover from a Suspect db on SQL Server 2005 Standard Service Pack2
---Error: 3414, Severity: 21, State: 1.
--During redoing of a logged operation in database 'MY_DB', an error occurred at log record ID (5006:4238:75).
--Typically, the specific failure is previously logged as an error in the ......
|
|
-
|
|
The following command line brings up all instance names and asks to select
an instance and then a few button clicks.
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\ARPWrapper.exe"
/Remove
Ensure you have backed up registry settings PRIOR to running the code.
For more information, chec......
|
|
-
|
|
From tomorrow, I’m posting a series of articles on Performance Tuning overview. The focus is not specific configurations or platform specific techniques. It’s a summary of general techniques, which DBAs can apply to most systems.
In most cases the DBA weighs up the cost versus benef......
|
|
-
|
|
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......
|
|
-
|
|
Use SET SHOWPLAN_XML instead of SET SHOWPLAN_TEXT or SET SHOWPLAN_ALL. Microsoft announced at the SQL Server 2008 release, SET SHOWPLAN_TEXT or SET SHOWPLAN_ALL are deprecated.
The advantage of using SET SHOWPLAN_XML ON is that the code is not executed. Executing the t-sql returns the exec......
|
|