I believe that I have a performance issue with one of my new servers. The
server is a dedicated SQL box. It's running Windows2003 and SQLServer2000.
I'm in the early stages of preping the server for production use. I notice
when I create a database, it takes 5 - 6 minutes. The same statement of my
laptop takes 30 - 45 seconds. Any ideas on what the issue could be? I
certainly have more disk and memory available on the server than my old
laptop. The database creation statement is as follows:
CREATE DATABASE [Test] ON (NAME='TestData', FILENAME='d:\sqldata\Test.mdf',
SIZE =999, FILEGROWTH=20%) LOG ON (NAME='TestLog',
FILENAME='d:\sqldata\Test.ldf' , SIZE = 10, FILEGROWTH = 30%)
--
TomRAID 5?
(Seems to bit too much of a slow down even for RAID 5, but who knows...).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
news:AFDF9C49-0D9D-4453-8F66-2C9972559A54@.microsoft.com...
>I believe that I have a performance issue with one of my new servers. The
> server is a dedicated SQL box. It's running Windows2003 and SQLServer2000.
> I'm in the early stages of preping the server for production use. I notice
> when I create a database, it takes 5 - 6 minutes. The same statement of my
> laptop takes 30 - 45 seconds. Any ideas on what the issue could be? I
> certainly have more disk and memory available on the server than my old
> laptop. The database creation statement is as follows:
> CREATE DATABASE [Test] ON (NAME='TestData', FILENAME='d:\sqldata\Test.mdf',
> SIZE =999, FILEGROWTH=20%) LOG ON (NAME='TestLog',
> FILENAME='d:\sqldata\Test.ldf' , SIZE = 10, FILEGROWTH = 30%)
> --
> Tom
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment