win/sql server 2008

1. Moving from Informix to SQL Server for an ERP system, what tools are available to analyze inputs/outputs, optimize performance and identify bottlenecks during stress testing in the win/sql server environment?

2. Wanting to hire help to do this.  Is Microsoft's Gold Partner program a good place to start?

3.  Are there ways to move 4gl over to vb script or other Microsoft tool?
KeithMcElroyAsked:
Who is Participating?
 
David ToddSenior DBACommented:
Hi,

1. SQL/Windows - there is the Performance Monitor. There are Dynamic Management Views in SQL. See http://www.bradmcgehee.com/2010/07/free-sql-server-dmv-starter-pack/

2. A fair idea. But do check on their references for SQL work and experience.

HTH
  David

 
0
 
David ToddSenior DBACommented:
PS Look for SQL experts to hire here at Experts Exchange!
0
 
KeithMcElroyAuthor Commented:
How do I approach starting a dialog with an expert for purposes of a project?  
Ideally, would be area specific, Southern Cal, Orange County, San diego area.
Although remote could work too.
My email is [MODERATOR EDIT]
0
 
KeithMcElroyAuthor Commented:
Will award points, just want to be sure I can receive reply to my last
0
 
David ToddSenior DBACommented:
Hi Keith,

I'm not sure as location isn't as far as I recall part of the profile. Otherwise it is look at experts profiles from your topic area. There is a Hall of Fame in the experts view that ranks experts via their points for Week, Month, Year (default), overall.

I'd suggest asking the above in the community support.

Maybe worth another question here ie Want to hire an expert ...

HTH
  David
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.