July 22, 2011 at 1:01 pm
I've seen that, and had trouble getting it to work for SQL Server 2008. Never put much effort into it. In general, I find SQL Server Reporting Services, and thereby any tool built on top of its infrastructure, to be poorly designed and ill-thought out. For example, the index report built-in to SSMS 2008 is stupid and doesn't take into account internal vs. external fragmentation! Ugh. And it is proprietary so you can't open the code that wrote the report and change it. How dumb. And it doesn't have workflow integrated, for push-button resolution of problems.
It is only a matter of time (20 years? :)) before Microsoft wakes up, buys Tableau Software (the best reporting tool out there), and re-engineers SSIS to work more like Google Refine (a free tool not currently geared toward massive ETL, but could be).
We will have to wait a long time, primarily due to reporting zombies who are satisfied with the status quo.
My current pet project is to build a performance dashboard with PowerShell that automatically launches, in sync, PerfMon traces and SQLserver server-side traces simultaneously and gathers the data and reports it in a useful manner. It was inspired by dealing with how stupid SQL Server Management Studio is. I tried talking to the guys who designed SSMS and SMO and basically got thumbs-in-ears replies.
As a software developer, I hate looking at the tools DBAs torture themselves with and know that it is still the best they have available.
July 23, 2011 at 8:13 am
I think you and I have different perspectives on things. I was a software developer for over 25 years, wrote about a half a million lines of source code in 10 different languages, and I don't have a problem with most of the tools available to me, as a DBA, from Microsoft. I find them to generally be adequate, and in some cases excellent, for everything a senior DBA needs to do.
If you're inclined to further investigate SQL Server Performance Dashboard, this link will provide you with a simple fix that will allow you to execute it on SS2008: http://blogs.technet.com/b/rob/archive/2009/02/18/performance-dashboard-reports-for-sql-server-2008.aspx
LC
March 31, 2014 at 5:55 am
Our SQL production servers have now been re-engineered to use compellent backup technology. I have the backup files taken with compellent from the production server and wants to restore the files to our SQL test server. I created the scripts for the refresh below but the job runs endlessly with no failures but nothing gets done. Please help.
Here are the scripts I am using.
powershell -File “C:\Scripts\Compellent\NEO_DB_Dismount_Replay.ps1”
powershell -File “C:\Scripts\Compellent\NEO_Log_Dismount_Replay.ps1”
powershell -File “C:\Scripts\Compellent\NEO_DB_Mount_Replay.ps1”
powershell -File “C:\Scripts\Compellent\NEO_Log_Mount_Replay.ps1”
CREATE DATABASE PROCESSDB_CLONE
ON
(FILENAME = 'C:\MP\MP001\SQL\Data\processdb.mdf'),
(FILENAME = 'C:\MP\MP001\SQL\Data\processdb_1.ndf'),
(FILENAME = 'C:\MP\MP001\SQL\Data\processdb_2.ndf'),
(FILENAME = 'C:\MP\MP001\SQL\Data\processdb_3.ndf'),
(FILENAME = 'C:\MP\MP002\SQL\Logs\processdb_4.ldf'),
(FILENAME = 'C:\MP\MP002\SQL\Logs\processdb_5.ldf')
FOR ATTACH
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply