memory usage and configuration...

How much memory is in your system in total, and what is
your drive configuration beyond the 6 disk RAID 5 set for
SQL Server? That may not be enough spindles, but I can't
say for sure. If you stick all of your SQL Server files
(system DBs, data/index, logs, tempdb) all on the same
stripe set, you are not buying yourself anything.
So if your goal as I saw is to put everything on the one
R5 stripe, I'd say wholeheartedly no, it is not an optimal
setup at all based on my experience.
However, you need to have done some system profiling to
tell you definitively.
I've 4gb of RAM
I want to control the usage of my hard drive to keep a good performance.
it's why I want to separate the tempdb database in 1 disk or 2 stripped
disks.
And I'll keep 4 disks in raid 5 for my data. for security reasons.
Maybe I can put my indexes on a separate disk.
Config 1:
Disk0: OS + Applications (10Gb only)
Disk0,1: Stripped - 22Gb + 32 Gb - tempdb - user db indexes - Swap file
Disk3,4,5,6: Raid 5 for system DB and user DB
Config 2:
Disk0: OS + Swap + Applications (10Gb only)
Disk0: tempdb (22gb)
Disk1: indexes (32gb)
Disk3,4,5,6: Raid 5 for system DB and user DB
each disk is a 32gb disk
what do you think about this?
which config is better?
or what is your recommendation?
Also, what is the swap file size required?
"Allan Hirt" <anonymous@.discussions.microsoft.com> a crit dans le message
de news:5ab501c474a8$a67500b0$a601280a@.phx.gbl...
> How much memory is in your system in total, and what is
> your drive configuration beyond the 6 disk RAID 5 set for
> SQL Server? That may not be enough spindles, but I can't
> say for sure. If you stick all of your SQL Server files
> (system DBs, data/index, logs, tempdb) all on the same
> stripe set, you are not buying yourself anything.
> So if your goal as I saw is to put everything on the one
> R5 stripe, I'd say wholeheartedly no, it is not an optimal
> setup at all based on my experience.
> However, you need to have done some system profiling to
> tell you definitively.

memory usage and configuration...

How much memory is in your system in total, and what is
your drive configuration beyond the 6 disk RAID 5 set for
SQL Server? That may not be enough spindles, but I can't
say for sure. If you stick all of your SQL Server files
(system DBs, data/index, logs, tempdb) all on the same
stripe set, you are not buying yourself anything.
So if your goal as I saw is to put everything on the one
R5 stripe, I'd say wholeheartedly no, it is not an optimal
setup at all based on my experience.
However, you need to have done some system profiling to
tell you definitively.I've 4gb of RAM
I want to control the usage of my hard drive to keep a good performance.
it's why I want to separate the tempdb database in 1 disk or 2 stripped
disks.
And I'll keep 4 disks in raid 5 for my data. for security reasons.
Maybe I can put my indexes on a separate disk.
Config 1:
Disk0: OS + Applications (10Gb only)
Disk0,1: Stripped - 22Gb + 32 Gb - tempdb - user db indexes - Swap file
Disk3,4,5,6: Raid 5 for system DB and user DB
Config 2:
Disk0: OS + Swap + Applications (10Gb only)
Disk0: tempdb (22gb)
Disk1: indexes (32gb)
Disk3,4,5,6: Raid 5 for system DB and user DB
each disk is a 32gb disk
what do you think about this?
which config is better?
or what is your recommendation?
Also, what is the swap file size required?
"Allan Hirt" <anonymous@.discussions.microsoft.com> a crit dans le message
de news:5ab501c474a8$a67500b0$a601280a@.phx.gbl...
> How much memory is in your system in total, and what is
> your drive configuration beyond the 6 disk RAID 5 set for
> SQL Server? That may not be enough spindles, but I can't
> say for sure. If you stick all of your SQL Server files
> (system DBs, data/index, logs, tempdb) all on the same
> stripe set, you are not buying yourself anything.
> So if your goal as I saw is to put everything on the one
> R5 stripe, I'd say wholeheartedly no, it is not an optimal
> setup at all based on my experience.
> However, you need to have done some system profiling to
> tell you definitively.

Memory Problem or else.

Hi Derek.
I just started lessons to read Chinese last week, but I'm afraid the images
you sent were a bit beyond my limited abilities yet (c:
If you translated the messages to English for us, you'd probably have a
better chance at getting a good answer to your question.
Regards,
Greg Linwood
SQL Server MVP
"Derek" <dalikyim@.netvigator.com> wrote in message
news:bvch66$ji21@.imsp212.netvigator.com...

quote:

---

> Hi,
> When I runing the embedded Visual Basic 3.0 on Win2K computer,
> I create a form and add a button, and then run it.
> The program break with this error. (see attached picture)
> Anyone know what is this error. Memory problem, Window 2000 system error
> or Embedded Visual Basic 3.0 problem ?
> On the other hand, when I install MS SQL server 2000, I also got this

---

error

quote:

---

> during installation, the setup is break.
> Anyone me these such kind of case ?
> Please advise.
> Thanks.
> Derek
>
>

---

Try setting your locale on your PC to US when installing the Eval software,
the _MP error is an installshield error and others have reported that
switching to US locale allowed the install to go ahead. You may well be able
to switch back once the install has completed
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Derek" <dalikyim@.netvigator.com> wrote in message
news:bvch66$ji21@.imsp212.netvigator.com...

quote:

---

> Hi,
> When I runing the embedded Visual Basic 3.0 on Win2K computer,
> I create a form and add a button, and then run it.
> The program break with this error. (see attached picture)
> Anyone know what is this error. Memory problem, Window 2000 system error
> or Embedded Visual Basic 3.0 problem ?
> On the other hand, when I install MS SQL server 2000, I also got this

---

error

quote:

---

> during installation, the setup is break.
> Anyone me these such kind of case ?
> Please advise.
> Thanks.
> Derek
>
>

---