smthembu (10/13/2009)

---

Hi

When i execute spaceanalysis.job it fails with the below or is it me

Msg 206, Level 16, State 2, Procedure sp_add_jobstep, Line 0
Operand type clash: int is incompatible with uniqueidentifier

& C:\bin\Write-VolToDb.ps1  ' Z002\SQL2K8'  spacedm

& C:\bin\Write-DbSpaceToDb.ps1 ' Z002\SQL2K8' spacedm

eric.simbozel-943459 (10/13/2009)

---

Do you have a Spaceanalysis.sln for BIDS 2005 please

Wanderer (10/13/2009)

---

Interesting stuff. we have something similar using SQL agent jobs, and SSRS.

Unless I missed it, the prediciton doesn't seem to have methods for predicting impact of reindexing and check database activities. Do you have metrics for establishing the peak DB size, or else of predicting the space required for that? We find that it is during the maintenance that our space alerts (85%, 90% etc.) most commonly trigger.

vinodkn (10/14/2009)

---

Look like very usefull stuff, thanks but cant try with out spacedm.procedures.sql
can you please copy paste the procedures in the article itself.

I tried downloading it from following link too but cant find spacedm.procedures.sql there also

http://ddi59g.blu.livefilestore.com/y1p-lPWTbCLIn7R0-1VuM3g9iuCYpwwooYuPY8QPoGLu-hUq99CpAqc0CrHP53p_NjyRU8ZXBb2vtuY8lIfu7Oecg/SpaceAnalysis.zip?

graeme.black (10/14/2009)

---

Hi

I am stepping thorugh the various steps, but when I try to launch the powershell scripts, I get the following error

C:\BIN>WRITE-DBSPACETODB.PS1
Exception calling "Fill" with "1" argument(s): "Invalid object name 'server_spa
ce_lku'."
At C:\BIN\Write-DbSpaceToDb.ps1:13 char:15
+ [void]$da.fill( <<<< $dt)

I have the following entry in 'Server_space)lku'

servname\instance