September 5, 2007 at 9:39 am
hi all,
I haven't posted in a while. I'm at a new job and just given more SQL responsibilities here. Were currently running Sharepoint 2003 on a sql 2000 environment (server also has the index and web server processes running).
Were considering going to a 64 bit version of SQL 2005 for the upgrade to Sharepoint 2007 (seperating all servers) and also going to a VMWare environment.
Anyone have any experience doing this? Also, the other servers in the environment would still be win 2003 32 bit.
Also, I've never run much with SQL Profiler and I'd like to see how taxed our current SQL environment is, so i'm gonna continue to search for a good tutorial. Thanks in advance for any advice. Thanks!
September 5, 2007 at 9:53 pm
Can't help you with your 64 bit question but if you want to find out how taxed your server is, performance monitor is the tool to use. Have a look at http://www.sql-server-performance.com/articles/per/trend_analysis_performance_monitor_pt1_p1.aspx - this gives you stacks of info on what counters to look at and how to interpret them
September 6, 2007 at 7:35 am
Check out Performance Dashboard which is a free download from microsoft if you are running SQL2005 sp2. It's a little easier to look at than perfmon I think and lists the queries using the most cpu, io or time so you can focus on whats hurting most. It will also recommend indexes. Looks at things from a slightly different angle than perfmon so you may want to try both. I'm using 64bit SQL 2005. In my experience it's definitely worth splitting Web and DB services onto separate servers.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply