Hi All,
I tried to install the new performance dashboards on 2005 sp2 on
windows 2003 and received the following error messages.
Has anyone seen these before? I know it is quite new...
Thanks
Peter
Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
'object_schema_name' is not a recognized built-in function name.
Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
Incorrect syntax near the keyword 'as'.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'usp_GetPageDetails', because it does not exist
or you do not have permission.
Did you run the sql script that came with the download?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegr oups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>
|||
> GUEST wrote:
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not
exist
> or you do not have permission.
I am getting the same error.
What is the fix for this if the server is on sp2?
|||On May 22, 6:54 pm, stacey.do...@.shawinc-dot-com.no-spam.invalid
(sdoran) wrote:
> exist
> I am getting the same error.
> What is the fix for this if the server is on sp2?
Same error here - SQL 2005 SP2 Latest hotfixes, etc. Any fix for
this?
Showing posts with label messages. Show all posts
Showing posts with label messages. Show all posts
Friday, March 30, 2012
Installing new performance dashboard for SQL Server 2005 SP2
Hi All,
I tried to install the new performance dashboards on 2005 sp2 on
windows 2003 and received the following error messages.
Has anyone seen these before? I know it is quite new...
Thanks
Peter
Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
'object_schema_name' is not a recognized built-in function name.
Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
Incorrect syntax near the keyword 'as'.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'usp_GetPageDetails', because it does not exist
or you do not have permission.Did you run the sql script that came with the download?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegroups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>|||The fact that you get an error about 'object_schema_name' suggests SP2 is
not installed on the instance since this is a new function added by SP2. Try
(re)applying SP2 to the instance to see if that resolves the issue.
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
http://sqlblogcasts.com/blogs/sqldbatips
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegroups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>|||
> GUEST wrote:
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not
exist
> or you do not have permission.
I am getting the same error.
What is the fix for this if the server is on sp2?|||On May 22, 6:54 pm, stacey.do...@.shawinc-dot-com.no-spam.invalid
(sdoran) wrote:
>
> exist
> I am getting the same error.
> What is the fix for this if the server is on sp2?
Same error here - SQL 2005 SP2 Latest hotfixes, etc. Any fix for
this?sql
I tried to install the new performance dashboards on 2005 sp2 on
windows 2003 and received the following error messages.
Has anyone seen these before? I know it is quite new...
Thanks
Peter
Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
'object_schema_name' is not a recognized built-in function name.
Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
Incorrect syntax near the keyword 'as'.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'usp_GetPageDetails', because it does not exist
or you do not have permission.Did you run the sql script that came with the download?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegroups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>|||The fact that you get an error about 'object_schema_name' suggests SP2 is
not installed on the instance since this is a new function added by SP2. Try
(re)applying SP2 to the instance to see if that resolves the issue.
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
http://sqlblogcasts.com/blogs/sqldbatips
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegroups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>|||
> GUEST wrote:
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not
exist
> or you do not have permission.
I am getting the same error.
What is the fix for this if the server is on sp2?|||On May 22, 6:54 pm, stacey.do...@.shawinc-dot-com.no-spam.invalid
(sdoran) wrote:
>
> exist
> I am getting the same error.
> What is the fix for this if the server is on sp2?
Same error here - SQL 2005 SP2 Latest hotfixes, etc. Any fix for
this?sql
Installing new performance dashboard for SQL Server 2005 SP2
Hi All,
I tried to install the new performance dashboards on 2005 sp2 on
windows 2003 and received the following error messages.
Has anyone seen these before? I know it is quite new...
Thanks
Peter
Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
'object_schema_name' is not a recognized built-in function name.
Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
Incorrect syntax near the keyword 'as'.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'usp_GetPageDetails', because it does not exist
or you do not have permission.Did you run the sql script that came with the download?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegroups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>|||The fact that you get an error about 'object_schema_name' suggests SP2 is
not installed on the instance since this is a new function added by SP2. Try
(re)applying SP2 to the instance to see if that resolves the issue.
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
http://sqlblogcasts.com/blogs/sqldbatips
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegroups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>|||> GUEST wrote
> Hi All
> I tried to install the new performance dashboards on 2005 sp2 o
> windows 2003 and received the following error messages
>
> Has anyone seen these before? I know it is quite new..
>
> Thank
>
> Pete
>
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 2
> 'object_schema_name' is not a recognized built-in function name
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 4
> Incorrect syntax near the keyword 'as'
> Msg 15151, Level 16, State 1, Line
> Cannot find the object 'usp_GetPageDetails', because it does no
exis
> or you do not have permission
I am getting the same error
What is the fix for this if the server is on sp2|||On May 22, 6:54 pm, stacey.do...@.shawinc-dot-com.no-spam.invalid
(sdoran) wrote:
> > GUEST wrote:
> > Hi All,
> > I tried to install the new performance dashboards on 2005 sp2 on
> > windows 2003 and received the following error messages.
> >
> > Has anyone seen these before? I know it is quite new...
> >
> > Thanks
> >
> > Peter
> >
> >
> > Msg 195, Level 15, State 10, Procedureusp_GetPageDetails, Line 27
> > 'object_schema_name' is not a recognized built-in function name.
> > Msg 156, Level 15, State 1, Procedureusp_GetPageDetails, Line 42
> > Incorrect syntax near the keyword 'as'.
> > Msg 15151, Level 16, State 1, Line 1
> > Cannot find the object 'usp_GetPageDetails', because it does not
> exist
> > or you do not have permission.
> I am getting the same error.
> What is the fix for this if the server is on sp2?
Same error here - SQL 2005 SP2 Latest hotfixes, etc. Any fix for
this?
I tried to install the new performance dashboards on 2005 sp2 on
windows 2003 and received the following error messages.
Has anyone seen these before? I know it is quite new...
Thanks
Peter
Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
'object_schema_name' is not a recognized built-in function name.
Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
Incorrect syntax near the keyword 'as'.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'usp_GetPageDetails', because it does not exist
or you do not have permission.Did you run the sql script that came with the download?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegroups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>|||The fact that you get an error about 'object_schema_name' suggests SP2 is
not installed on the instance since this is a new function added by SP2. Try
(re)applying SP2 to the instance to see if that resolves the issue.
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
http://sqlblogcasts.com/blogs/sqldbatips
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegroups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>|||> GUEST wrote
> Hi All
> I tried to install the new performance dashboards on 2005 sp2 o
> windows 2003 and received the following error messages
>
> Has anyone seen these before? I know it is quite new..
>
> Thank
>
> Pete
>
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 2
> 'object_schema_name' is not a recognized built-in function name
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 4
> Incorrect syntax near the keyword 'as'
> Msg 15151, Level 16, State 1, Line
> Cannot find the object 'usp_GetPageDetails', because it does no
exis
> or you do not have permission
I am getting the same error
What is the fix for this if the server is on sp2|||On May 22, 6:54 pm, stacey.do...@.shawinc-dot-com.no-spam.invalid
(sdoran) wrote:
> > GUEST wrote:
> > Hi All,
> > I tried to install the new performance dashboards on 2005 sp2 on
> > windows 2003 and received the following error messages.
> >
> > Has anyone seen these before? I know it is quite new...
> >
> > Thanks
> >
> > Peter
> >
> >
> > Msg 195, Level 15, State 10, Procedureusp_GetPageDetails, Line 27
> > 'object_schema_name' is not a recognized built-in function name.
> > Msg 156, Level 15, State 1, Procedureusp_GetPageDetails, Line 42
> > Incorrect syntax near the keyword 'as'.
> > Msg 15151, Level 16, State 1, Line 1
> > Cannot find the object 'usp_GetPageDetails', because it does not
> exist
> > or you do not have permission.
> I am getting the same error.
> What is the fix for this if the server is on sp2?
Same error here - SQL 2005 SP2 Latest hotfixes, etc. Any fix for
this?
Friday, March 23, 2012
Installing 2000 SQL -- Suggestions?
Hello,
I am in the process of installing our first SQL server in house and after
reading several messages here from this group I have a few questions.
Fist of all, we are having to go with SQL 2000 as both of our applications
we are wanting to move to a SQL enviroment only support SQL 2000 (SQL 2005
is not supported). I already have a WIN2003 AD environment and the new
'rebuilt' server will be a WIN2003/SQL 2000.
How should I configure the hard drives on the new server (I am going to
rebuild the box). Should I use RAID 0,1 or 5? Currently it is a Dell 2600
Dual 2.6 Processor 2GB RAM W2K RAID 5 box. I have heard that we will take a
performance hit with RAID 5? What are the RAID pros/cons from a SQL point?
Any tips or suggestions for installing SQL 2000 are GREATLY appreciated!
Thanks for your help!!!Your best performance will happen in Raid 10,this is for storage of the MDF
file.If to expensive use Raid 5.
To maximise I/O in either 5 or 10 use as many physical disks in the array
as supported by controller .As this facilitates read/write to be performed
simultaneously.
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Mark" <someone@.somewhere@.in.the.world.com> wrote in message
news:OG9#RV#ZGHA.440@.TK2MSFTNGP05.phx.gbl...
> Hello,
> I am in the process of installing our first SQL server in house and after
> reading several messages here from this group I have a few questions.
> Fist of all, we are having to go with SQL 2000 as both of our applications
> we are wanting to move to a SQL enviroment only support SQL 2000 (SQL 2005
> is not supported). I already have a WIN2003 AD environment and the new
> 'rebuilt' server will be a WIN2003/SQL 2000.
> How should I configure the hard drives on the new server (I am going to
> rebuild the box). Should I use RAID 0,1 or 5? Currently it is a Dell
2600
> Dual 2.6 Processor 2GB RAM W2K RAID 5 box. I have heard that we will take
a
> performance hit with RAID 5? What are the RAID pros/cons from a SQL
point?
> Any tips or suggestions for installing SQL 2000 are GREATLY appreciated!
> Thanks for your help!!!
>
>
I am in the process of installing our first SQL server in house and after
reading several messages here from this group I have a few questions.
Fist of all, we are having to go with SQL 2000 as both of our applications
we are wanting to move to a SQL enviroment only support SQL 2000 (SQL 2005
is not supported). I already have a WIN2003 AD environment and the new
'rebuilt' server will be a WIN2003/SQL 2000.
How should I configure the hard drives on the new server (I am going to
rebuild the box). Should I use RAID 0,1 or 5? Currently it is a Dell 2600
Dual 2.6 Processor 2GB RAM W2K RAID 5 box. I have heard that we will take a
performance hit with RAID 5? What are the RAID pros/cons from a SQL point?
Any tips or suggestions for installing SQL 2000 are GREATLY appreciated!
Thanks for your help!!!Your best performance will happen in Raid 10,this is for storage of the MDF
file.If to expensive use Raid 5.
To maximise I/O in either 5 or 10 use as many physical disks in the array
as supported by controller .As this facilitates read/write to be performed
simultaneously.
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Mark" <someone@.somewhere@.in.the.world.com> wrote in message
news:OG9#RV#ZGHA.440@.TK2MSFTNGP05.phx.gbl...
> Hello,
> I am in the process of installing our first SQL server in house and after
> reading several messages here from this group I have a few questions.
> Fist of all, we are having to go with SQL 2000 as both of our applications
> we are wanting to move to a SQL enviroment only support SQL 2000 (SQL 2005
> is not supported). I already have a WIN2003 AD environment and the new
> 'rebuilt' server will be a WIN2003/SQL 2000.
> How should I configure the hard drives on the new server (I am going to
> rebuild the box). Should I use RAID 0,1 or 5? Currently it is a Dell
2600
> Dual 2.6 Processor 2GB RAM W2K RAID 5 box. I have heard that we will take
a
> performance hit with RAID 5? What are the RAID pros/cons from a SQL
point?
> Any tips or suggestions for installing SQL 2000 are GREATLY appreciated!
> Thanks for your help!!!
>
>
Installing 2000 SQL -- Suggestions?
Hello,
I am in the process of installing our first SQL server in house and after
reading several messages here from this group I have a few questions.
Fist of all, we are having to go with SQL 2000 as both of our applications
we are wanting to move to a SQL enviroment only support SQL 2000 (SQL 2005
is not supported). I already have a WIN2003 AD environment and the new
'rebuilt' server will be a WIN2003/SQL 2000.
How should I configure the hard drives on the new server (I am going to
rebuild the box). Should I use RAID 0,1 or 5? Currently it is a Dell 2600
Dual 2.6 Processor 2GB RAM W2K RAID 5 box. I have heard that we will take a
performance hit with RAID 5? What are the RAID pros/cons from a SQL point?
Any tips or suggestions for installing SQL 2000 are GREATLY appreciated!
Thanks for your help!!!Your best performance will happen in Raid 10,this is for storage of the MDF
file.If to expensive use Raid 5.
To maximise I/O in either 5 or 10 use as many physical disks in the array
as supported by controller .As this facilitates read/write to be performed
simultaneously.
--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Mark" <someone@.somewhere@.in.the.world.com> wrote in message
news:OG9#RV#ZGHA.440@.TK2MSFTNGP05.phx.gbl...
> Hello,
> I am in the process of installing our first SQL server in house and after
> reading several messages here from this group I have a few questions.
> Fist of all, we are having to go with SQL 2000 as both of our applications
> we are wanting to move to a SQL enviroment only support SQL 2000 (SQL 2005
> is not supported). I already have a WIN2003 AD environment and the new
> 'rebuilt' server will be a WIN2003/SQL 2000.
> How should I configure the hard drives on the new server (I am going to
> rebuild the box). Should I use RAID 0,1 or 5? Currently it is a Dell
2600
> Dual 2.6 Processor 2GB RAM W2K RAID 5 box. I have heard that we will take
a
> performance hit with RAID 5? What are the RAID pros/cons from a SQL
point?
> Any tips or suggestions for installing SQL 2000 are GREATLY appreciated!
> Thanks for your help!!!
>
>sql
I am in the process of installing our first SQL server in house and after
reading several messages here from this group I have a few questions.
Fist of all, we are having to go with SQL 2000 as both of our applications
we are wanting to move to a SQL enviroment only support SQL 2000 (SQL 2005
is not supported). I already have a WIN2003 AD environment and the new
'rebuilt' server will be a WIN2003/SQL 2000.
How should I configure the hard drives on the new server (I am going to
rebuild the box). Should I use RAID 0,1 or 5? Currently it is a Dell 2600
Dual 2.6 Processor 2GB RAM W2K RAID 5 box. I have heard that we will take a
performance hit with RAID 5? What are the RAID pros/cons from a SQL point?
Any tips or suggestions for installing SQL 2000 are GREATLY appreciated!
Thanks for your help!!!Your best performance will happen in Raid 10,this is for storage of the MDF
file.If to expensive use Raid 5.
To maximise I/O in either 5 or 10 use as many physical disks in the array
as supported by controller .As this facilitates read/write to be performed
simultaneously.
--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Mark" <someone@.somewhere@.in.the.world.com> wrote in message
news:OG9#RV#ZGHA.440@.TK2MSFTNGP05.phx.gbl...
> Hello,
> I am in the process of installing our first SQL server in house and after
> reading several messages here from this group I have a few questions.
> Fist of all, we are having to go with SQL 2000 as both of our applications
> we are wanting to move to a SQL enviroment only support SQL 2000 (SQL 2005
> is not supported). I already have a WIN2003 AD environment and the new
> 'rebuilt' server will be a WIN2003/SQL 2000.
> How should I configure the hard drives on the new server (I am going to
> rebuild the box). Should I use RAID 0,1 or 5? Currently it is a Dell
2600
> Dual 2.6 Processor 2GB RAM W2K RAID 5 box. I have heard that we will take
a
> performance hit with RAID 5? What are the RAID pros/cons from a SQL
point?
> Any tips or suggestions for installing SQL 2000 are GREATLY appreciated!
> Thanks for your help!!!
>
>sql
Subscribe to:
Posts (Atom)