August 3, 2006 at 6:12 am
Below are the performance monitoring stats on my SQL box:This was for a 24hour period
It has the following specs
SQL server standard
SAN disks
DB file and Log file are on thesame drive H:
Dual CPU Xenon processors
The Database is relatively slow,I started defraging the indexes, improved a bit, but is there anything else we can do ?
| Memory_Page_Reads_sec | 1.1438500664 |
| Memory_Page_Reads_sec | 225.6081965 |
| Memory_Pages_sec | 13.47739648 |
| PhysicalDisk_Time_Disk_H_SAN | 1229.062161 |
| PhysicalDisk_Disk_Bytes_Write_DISK_H_SAN | 56774.78697 |
| PhysicalDisk_Disk_Queue_Length | 12.29091227 |
| CPU_TIME | 61.11675119 |
| System_Processor_Queue_Length | 17.23594726 |
August 4, 2006 at 11:20 am
Here's my 'short list' for tuning:
Round I
DBCC UPDATEUSAGE
UPDATE STATISTICS (with FULL scan) for all tables
exec sp_recompile for all tables
exec sp_refreshview for all views
Round II
DBCC DBREINDEX
UPDATE STATISTICS (with FULL scan) for all tables
exec sp_recompile for all tables
exec sp_refreshview for all views
Round III
Profiler
Query Hints
You also might want to pay a visit to http://www.sql-server-performance.com/ as well and check out the articles on perfmon and the counters that need monitoring.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
August 4, 2006 at 2:51 pm
Profile your server and watch which queries are performing bad.
Normally you should always seperate your log from your data files. But there are tons of things to do and not to do for optimal performance.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply