SQL Server Performance Forum – Threads Archive
Server Performance
We have added a new DB on our SQL-Server, which already have a DB with 105 users. I have to find out what is the affect of the new DB on the server’s performance. What is your suggestion? We have SQL2000 on Win2000 on a box with 4 x 2.8 Xeon processors. CanadaDBAYou should take a baseline performance benchmark over a couple of days of average workload. This would include performance monitor counters such as memory usage, disk queue etc.
Then repeat after the database has been added. Adding the new DB in itself will not affect performance, but it depends on how heavily it is used.. something maybe difficult to estimate until its live. Maybe you already have a server with that DB on, you could monitor that to give a rough idea of the reosurces it will consume on your new server
Hey Chappy, How can I take a baseline performance benchmark? How can I monitor memory usage, disk workload, …? We have only one server and both DB would be one that server. Thanks,
quote:Originally posted by Chappy
You should take a baseline performance benchmark over a couple of days of average workload. This would include performance monitor counters such as memory usage, disk queue etc.
Then repeat after the database has been added. Adding the new DB in itself will not affect performance, but it depends on how heavily it is used.. something maybe difficult to estimate until its live. Maybe you already have a server with that DB on, you could monitor that to give a rough idea of the reosurces it will consume on your new server
Then repeat after the database has been added. Adding the new DB in itself will not affect performance, but it depends on how heavily it is used.. something maybe difficult to estimate until its live. Maybe you already have a server with that DB on, you could monitor that to give a rough idea of the reosurces it will consume on your new server
CanadaDBA
You can use Performance Monitor with counters: Avg. Disk Queue Length for each disk, Index Searches/sec, Full Scans/sec, SQL Server Target Memory, Total SQL Server Memory, Page Faults/sec, Page Faults, % Processor Time, % Processor Time sqlsrv, Buffer Cache Hit Ratio. May I forget others. You have to create counters log with Performance Monitor, to save values and after see those values with excel (just an example), ir order to compare with new database. HTH Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
Hi FarhadR,<br /><br />If I read your post correctly, you have "already" added the new DB to the SQL Server. I guess both Chappy and Luis are replying to your post with the assumption that the new DB has not been added to the SQL Server. Since your SQL Server has the new DB, you just need to make sure that you get the benchmark when noone is accessing the new DB. <br /><br /><br />Hi Chappy and Luis,<br /><br />If my guess is wrong, please let me know. [<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]<br /><br /><br /><br />
http://www.sqljunkies.com/Article/7F8518F9-FDAA-4FF3-8FC5-25E8946C8D0C.scuk
http://www.sql-server-performance.com/sql_server_performance_audit.asp … are the articles for the baseline performance and findout any issues. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Thank you all for your replies. PCSQL, you are right but the answers are clear to me specially about "Performance Monitor" I had no idea and didn’t know what it is. The links that Satya provided are great and cleared everything for me. I am pleased to appreciate all helps. Thank you! CanadaDBA
]]>