Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
klabacita
Starting Member
2 Posts |
 Posted - 2012-07-30 : 18:01:28
|
Hi people. I have been working on benchmark my server where I will run sql-server 2008 r2. Now I had send that went my machine run the benchmarks with +8 threads io block size 128-256kb it give me the best numbers. Now that I know this, what can I do in sql-server to work with this settings? can Itook advantage of this info? What is next? Thanks  Windows 2008 R2 x64 Sql server 2008 R2 |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-07-31 : 03:47:11
|
| Depends what numbers you are benchmarking and what is the limiting factor for your system.Usually it's much better to concenntrate on the design and coding rather than this sort of thing. You can often improve performance by orders of magnitude - what increase do yoou expect to get from what you are doing?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
klabacita
Starting Member
2 Posts |
Posted - 2012-07-31 : 16:04:55
|
quote:
Originally posted by nigelrivett
Depends what numbers you are benchmarking and what is the limiting factor for your system.Usually it's much better to concenntrate on the design and coding rather than this sort of thing. You can often improve performance by orders of magnitude - what increase do yoou expect to get from what you are doing?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy.
Hi. I was asking about admin side, what I can do to give a good system, all the books speak about performance and that came of stuff, compare different installations, san, raid, etc. Thanks!!! |
|
|
|
sql-lover
Yak Posting Veteran
99 Posts |
Posted - 2012-08-04 : 00:21:38
|
| Use those values as a baseline.Go back and compare 4 weeks later and if you capture disk latency, see if went up or down. Check RAM utilization or page life expectancy. See if you can improve those values.Besides those numbers, I like to focus on the slowest query or the one that uses more IO in the system. Identifying that store procedure usually helps with the overall response and performance of the server. There are dozens of DMVs and TSQL snippets that you can find oline and show you that info. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-08-04 : 12:09:47
|
| klabactia - Is this information required for you to recommend purchasing within a company - such as RAID ? If so, it is also important to create a IO profile of the expected server activity. Different block sizes are used by different types of operations. For example, if you're commiting high levels of small transactions , then certain block sizes are of better use. I have some notes here based on similar experience: http://www.sqlserver-dba.com/2011/06/sql-server-io-patterns-and-raid-levels.htmlJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
|
|
sql benchmark, what is next?