Wednesday, March 28, 2012
RAID Configuration for SQL Server ...
We are rolling out an ERP application from MS across our
organisation. And we are using MS SQL Server as the back
end. In this regard, I have few queries -
a) What would be the optimum RAID configuration for the
SQL Server database? Can someone point me towards any
guide?
b) Still we are in the initial stage of our roll out. So
we are not too sure about the growth of database. Is
there any tools available for estimating the size of
database?
Thanks in advance,
Harish MohanbabuHi
You may want to check out the book "SQL Server 2000 Performance Tuning
Technical Reference" which talks about this in some depth ISBN 0-7356-1270-6
Also you may want to browse the site:
http://www.sql-server-performance.com/
Such as:
http://www.sql-server-performance.com/ultimate_sql_server.asp
The topic "Estimating the Size of a Database" in books online should help
you decide how big the data may get:
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\cre
atedb.chm::/cm_8_des_02_2h45.htm
John
"Harish Mohanbabu" <anonymous@.discussions.microsoft.com> wrote in message
news:067c01c3cdfb$2d441db0$a101280a@.phx.gbl...
> Hi,
> We are rolling out an ERP application from MS across our
> organisation. And we are using MS SQL Server as the back
> end. In this regard, I have few queries -
> a) What would be the optimum RAID configuration for the
> SQL Server database? Can someone point me towards any
> guide?
> b) Still we are in the initial stage of our roll out. So
> we are not too sure about the growth of database. Is
> there any tools available for estimating the size of
> database?
> Thanks in advance,
> Harish Mohanbabu|||Thanks for your kind and quick reply ....
>--Original Message--
>Hi
>You may want to check out the book "SQL Server 2000
Performance Tuning
>Technical Reference" which talks about this in some
depth ISBN 0-7356-1270-6
>Also you may want to browse the site:
>http://www.sql-server-performance.com/
>Such as:
>http://www.sql-server-
performance.com/ultimate_sql_server.asp
>The topic "Estimating the Size of a Database" in books
online should help
>you decide how big the data may get:
>mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%
20Server\80\Tools\Books\cre
>atedb.chm::/cm_8_des_02_2h45.htm
>John
Monday, February 20, 2012
Queue not disabling
HI There
My activated proc is rolling back the transaction and putting the message abck on the queue infinately ?
Normally it disabled the queue after a few rollbacks, i can see in the sql log that it just keeps rolling back and re-activating thousands of times.
It only stops when i disable activation on the queue.
WHy is the queue not disabling ?
Thanx
Did you look at sys.service_queues to see if the queue is really disabled? Does profiler show the queue_disabled event?|||Thanx Rushi
Thats what i thought just wanted to check Thanx
|||Sorry that comment was on the wrong post, yes i check sys.service_queues to make sure it is enabled. ANd i check the sql log and can see the activated sp activating and rolling abck thousands of times until i disable actiavtion. I find it very strange it always used to disable becuase of the poison message, but no longer not sure why, i would not even know how to disable poison messages?
Thanx