ms sql server is too slow - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

ms sql server is too slow

Author

Topic

putane.sanjay
Yak Posting Veteran

77 Posts

Posted - 2007-03-01 : 08:10:26

Hi,
i installeed ms sql server 2000 in local machine I have 3 databses.esch 800 mb size.Iam taking transactional backup for every 2 hours , full backup once in a week . deooferential backup every day.
system configuaration is p4,3.00ghz,2gb RAM,80 GB HARD DISK but ms sql server is runnig is too slow.
I checked performance monitor for sql server
buffer cache hit ratio 98.485,
connection memory 600 kb,
maximum workspace memory 729624 kb,
total server memory 76224kb

please i wating for ur suggestion to resolve this issue.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-03-01 : 08:56:06

first define too slow.
what exactly is so slow?
do you have indexing in place?

Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

putane.sanjay
Yak Posting Veteran

77 Posts

Posted - 2007-03-01 : 08:57:59

it is taking more time to open the database and tables

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-03-01 : 09:48:45

how long is more time?
how are you opening them?

you must provide more info on your situation if you'd like us to help you.

Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

rlaubert
Yak Posting Veteran

96 Posts

Posted - 2007-03-01 : 15:26:36

3 tools are available for you to monitor SQL. Performance Monitor (windows), Profiler and Execution plans. But without a base line (ie knowing what the readings were in the past) all you can really do is go with the books on line suggested settings for memory, hard drive, cpu etc.
Are you sure it is taking more time to open them? Perhaps have you set the options on the datbase to auto-close? As Spirit said, how much time is it taking and how long did it use to take. What changes have been made or were made just prior to this problem.

Raymond Laubert
MCDBA, MCITP:Administration, MCT

putane.sanjay
Yak Posting Veteran

77 Posts

Posted - 2007-03-02 : 10:27:51

through performance monitor
buffer cache hot ratio:99.818
database pages:2422
data files, size:3547072
log cache hit ratio:0.00
log file(s) used size (KB) : 836482
connection Memory (KB) : 328
lock blocks : 97
lock blocks allocated 0
lock memory (KB): 240
lock owner blocks : 97
lock owner blocks allocated : 2601
Maximum workspace memory (KB) : 871872
memory grants outstanding :0
memory grants pending : 0
Optimizer memory (KB): 0
SQL Cache memory (KB) : 272
Target Server Memory (KB) : 1111872
Active sessions : 1
Inactive sessions : 0
Total Sessions : 1
worktable cache ratio : 50.00
if i right click on databases in enterprise manager or if i run a query ( table having 15 records)in query analyzer my sql server is hanging.

mcrowley
Aged Yak Warrior

771 Posts

Posted - 2007-03-02 : 10:37:26

Is this slowness only in enterprise manager? Have you applied SP3 to the client in question?

putane.sanjay
Yak Posting Veteran

77 Posts

Posted - 2007-03-05 : 08:27:11

yes,and i have applied sp4

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources