I#%92m comes from the developer side and got the DBA role more or less thrown over me. I have work as developer for 10 years. And lately have big problem with performance issue on a server. My biggest problem at moment is where to start. We lack the routines for monitor server performance daily basic. 1.I have defined a real-time performance monitor view. But have no routine to log data to file or table for long time analysis or creating baseline for the server. From the view we were able to figure out that we have processor problem by looking at the processor queue length and processor time. To solve the immediate problem we got extra processor. 2.I have tested to make some server side traces. I have focus on the CPU Bottlenecks. My first was on detecting SQL Recompilations/sec to Batch Requests/sec. From that trace I#%92m made top 10 list. 3.My second attempt was to make a sql trace. From there we read in the information in to table and made â€œCUBEâ€ with executions/read+writes/cpu/duration. Made 10 then lists from different angles as top 10 applications, top 10 statement from writes/cpu etcâ€¦ But at moment we have around 1500 transactions/sec during peak hours in the database take up loot of space to make trace files and analyses the material. 4.I have played with the management views (not used to them), get list of non used indexes, lists recompiled statements etcâ€¦ 5.I have tested some tools like SQL Trace Analyzer etc. 6.Hired more skilled DBA to help me get started. My questions are as followedâ€¦ â€¢How are you working on your daily basic with performance problem? Are you making traces on a daily basic with working? â€¢Do you use dm to collect data or server-side traces? â€¢Do you use any tools like SQL Trace Analyzer or Spotlight? We are looking on this routine â€¢Make some type of Performance Monitor log to database. To create the baselineâ€¦ â€¢Build some automatic scripts that gives top 10 list from different angles â€¢Reads+Writes per Application/Database/Executions â€¢Work with index and smart application from the 10 lists to solve the problem.