Estimating the size of an SQL Server database

5 Posts
3 Users
0 Likes
25 Views
RM
 RM
(@r-martinarcinfo-com)
Posts: 56
Estimable Member
Topic starter
 

Can anyone help me estimate the disk space required for a PcVue Archive Unit using the HDS and SQL Server?

I have the following figures from the customer.

Storage requred for 10 years
There could be in the order of 500 trends, trended at say 1 minute intervals.
There could be in the order of 10,000 alarm/event tags, which change at an average rate of 200 events per minute.

I guess that it will be fairly big :ohmy:

Cheers

Robin

 
Posted : 07/12/2012 8:27 pm
(@r.buisson@arcinfo.com)
Posts: 31
Eminent Member Guest
 

Hi Robin,

you can look on this article in the KB:

https://support.pcvuescada.com/index.php?option=com_k2&view=item&id=291:method-of-calculating-the-sql-database-size-_-2005-or-2008&Itemid=49

In this article I take a customer case study, juste have to apadt to yours.

 
Posted : 07/12/2012 8:45 pm
RM
 RM
(@r-martinarcinfo-com)
Posts: 56
Estimable Member
Topic starter
 

Thanks Romain

I need to improve my search skills. I looked for this article but didn't find it. Now I have you link it is no problem!

Cheers

Robin

 
Posted : 07/12/2012 8:56 pm
(@r.buisson@arcinfo.com)
Posts: 31
Eminent Member Guest
 

You welcome, bit in my study case I only talk about trend table, you have to make the same with log table.

In log table mandatory columns and Clusterded index are the same. The difference is only on Not clustered index where you have to add all information put in log table.

 
Posted : 07/12/2012 9:03 pm
n.kunzer
(@n-kunzerarcinfo-com)
Posts: 1236
Member Moderator
 

Romain, I dont really understand your remark about the "not clustered index".
What I understood is that you can add a field in the "not clustered index" only if you want to request using this field.
Am I wrong?

 
Posted : 10/12/2012 8:08 am