Today I was looking the SQL Server Agent jobs on one of my SQL Server 2000 production database servers. I noticed one job that failed with a very cryptic error. This was the error message reported:
DTSRun OnStart: DTSStep_DTSDataPumpTask_6 DTSRun OnProgress:
DTSStep_DTSDataPumpTask_6; 1000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress:
DTSStep_DTSDataPumpTask_6; 2000 [...]
Hello again and welcome back!
The other day I was posting in the SQL Server news groups and I came across a person asking about which performance counters should be collected to obtain a performance load \ baseline in their production SQL Server environment. It occurred to me there is a lot of information out there [...]
The other day I was looking on a production SQL Server and I noticed a trace file that was running but was not able to associate it to SQL Profile session. I queried sysprocesses and was unable to find a spid that was running SQL Profile. I was perplexed for a little while and started [...]
Hello again and welcome back!
I thought today’s posting to my blog should cover how to get the results of DBCC CHECKDB into a table. Unfortunately, Microsoft does not allow you easily per se to insert the results into a table so that you might be able to generate administrative reports off of. Well in my [...]
The other day I came across a job posting that read “Principal SQL Server DBA” and thought perhaps I read that wrong. So it got my curiosity going and I thought I would check it out. As I read the description what came to mind was …. this company is looking for a “very senior” [...]
Today a junior DBA asked me about the files with the .STB extension were for. Then I realized that other DBAs out there may not know what the .STB files are for and what creates them. The .STB files stand for STand By (STB). These files are created when a database is [...]
When your application experiences a performance problem chances are some aspect of your application has or is hitting a bottleneck. What exactly is a bottleneck? Per Wikipedia a bottleneck is a phenomenon where the performance or capacity of an entire system is severely limited by a single component. A common single component [...]
Today I was going through one of my production SQL Servers and looking at the connections\spids it dawned on me that some people that are new to SQL Server might not know the different “states” of a worker thread. Here are 3 states that you will come across when executing sp_who or sp_who2:
Running - [...]
Hello and welcome back again…
After a little break I thought of what else people would be interested in and I thought about education. In my years of experience I have not seen an employer “want” or more to the point “request” a person that has an MCDBA. Employers seem to “want” people with [...]
Here is a stored procedure that will restore your database without having to remember the SQL syntax of the RESTORE DATABASE command in SQL Server 2000. This stored procedure is to be compiled and run from MSDB. The stored procedure reads from the registry to figure out the data and log path of [...]
25 queries / 0.278 seconds.