Re: Clustered Indexes
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/21/05
- Next message: Andrew J. Kelly: "Re: SQL 2000 Standard & RAM"
- Previous message: Mike Hodgson: "Re: msde login problem"
- In reply to: Jon A: "Re: Clustered Indexes"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 20 Feb 2005 23:09:41 -0500
Just FYI a 3 disk Raid 5 is the worst performing array there is for write
operations if the log file is also on the array. Are you sure there are no
other apps or services running on this machine? I don't know if you can
schedule profiler or not but you can schedule a trace. With sp_tracecreate
and it's associated sp's you can create a trace that writes to a file and
schedule that any time you want in sql agent. Maybe these links can give
you some thing to start with in dealing with performance.
http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp
Disk Monitoring
-- Andrew J. Kelly SQL MVP "Jon A" <JonA@discussions.microsoft.com> wrote in message news:F3BB4B49-44CF-457D-BABC-A4C396057B42@microsoft.com... > The machine is 2 processor P4 with 2 gig ram and a SCSI 3 disk raid 5 > with 32 meg ram. SQL has access to all 2 gig. They tried setting it to > 1.2gig and it didn't make a difference. So I am told! What would be the > best > counters for this issue in SQL Profiler and Perfmon? Can you schedual SQL > Profiler? >
- Next message: Andrew J. Kelly: "Re: SQL 2000 Standard & RAM"
- Previous message: Mike Hodgson: "Re: msde login problem"
- In reply to: Jon A: "Re: Clustered Indexes"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
