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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-04 : 09:23:20
|
| Uwe writes "Hye,i got a strange effect after i moved my sql-server 7.0 database to a new NT-server.The server (Fujitsu Siemens Primergy P200, 2x1200MHz P3, 2GB RAM, 4x36 U160 SCSI Disk on Mylex RAID Controller 16MB of RAM) has extremly heavy problems while backing up the database.The RAId is configured as 2x RAID 1, the first one for the OS and the software, the second one for the database/logs.The server performance very well on normal usage (6GB data, nearly 30.000 Users), the systemload is around 12-28%.But if i fireup my backup job (dumping hte database from the second to the first RAID) the SQL-Servers does no longer response requests, if he responses the answer is very very slow. When the backup has been done all works fine. There is no high systemload while the sql-servers backups the database, but hte system responses very slow.I tried the same on the old server (IBM netfinity 5500 M20, 2xXeon 550MHz, 2GB RAM, IBM Server-RAID, same disksize as the new one, same RAID configuration) and there the problem does not occure.Do you have any ideas how to speed up the performance? i think it is an I/O issue but the NT performancemonitor does not give correct informations on the I/O (shows nothing in the perfmon on disk-usage).Any ideas here on this? thanks for all helpregardsUwe" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-11-04 : 13:44:45
|
| In order to see disk performance counters in the Performance Monitor on a NT4.0 server, you have to run the diskperf utility at the command prompt and then reboot the server. This is the command: diskpref -y |
 |
|
|
|
|
|
|
|
SQL-Server backup bad I/O performance, Server does not repsonse