Monday, March 12, 2012

Reference Material Recommendations

I'm a relatively experienced SQL Server 2000/2005 development DBA/Programmer
but I'm up for a new position involving systems that are dealing in 1000s of
user transactions a second and I don't have any experience in that area.
Does anyone have suggestions for reading I can do to familiarize myself with
the specific hot points of that type of system?
Any help is appreciated.
Thanks
RCBThese are not all 2005 specific but might be a good start:
http://www.sql-server-performance.c...nce_audit10.asp
Performance Audit
http://www.microsoft.com/technet/pr...perfmonitor.asp Perfmon counters
http://www.sql-server-performance.c...mance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.c...rmance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/d.../>
on_24u1.asp
Disk Monitoring
http://sqldev.net/misc/WaitTypes.htm Wait Types
Tempdb in 2005:
http://download.microsoft.com/downl...gWithTempDB.doc
Physical Database Storage:
http://download.microsoft.com/downl...
PhysDBStor.doc
Andrew J. Kelly SQL MVP
"Robert B" <RobertB@.discussions.microsoft.com> wrote in message
news:0C9E5F9D-2F7A-4495-8CE8-018E3C358B9C@.microsoft.com...
> I'm a relatively experienced SQL Server 2000/2005 development
> DBA/Programmer
> but I'm up for a new position involving systems that are dealing in 1000s
> of
> user transactions a second and I don't have any experience in that area.
> Does anyone have suggestions for reading I can do to familiarize myself
> with
> the specific hot points of that type of system?
> Any help is appreciated.
> Thanks
> RCB|||Thanks for the list of articles, some were familiar to me some had some grea
t
information. Does anyone else know of any articles more about the 'design'
aspects of high transaction databases?
Thanks Again

No comments:

Post a Comment