Options for dealing with table Contention

Question

Options for dealing with table Contention

Viewing 5 posts - 31 through 34 (of 34 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736188 More actions · Answer 1

If you can, it would be great for you to capture a workload and then some CPU/mem/disk stats before and after compression. That would make a great article on a real world experience.

Garadin One Orange Chip Points: 29613 More actions · Answer 2

Steve Jones - Editor (4/5/2010)
If you can, it would be great for you to capture a workload and then some CPU/mem/disk stats before and after compression. That would make a great article on a real world experience.

Great idea, I'll see what I can do for this. I think figuring out the right stats to pull is a big part of it. Any tips anyone has to this regard are welcome. I'll probably do some reading on how to measure I/O and then track those stats.

Seth Phelabaum

Consistency is only a virtue if you're not a screwup. 😉

Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

Garadin One Orange Chip Points: 29613 More actions · Answer 3

Steve Jones - Editor (4/5/2010)
If that's the case, you might be surprised what compression does for you.

I know I like what it does to my DB size. From ~75gb down to ~20.

Seth Phelabaum

Consistency is only a virtue if you're not a screwup. 😉

Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

Steve Jones - Editor (4/5/2010)
If that's the case, you might be surprised what compression does for you.

I think I might be considerably surprised as well.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Paul White SSC Guru Points: 150467 More actions · Answer 5

Garadin (4/5/2010)
I think figuring out the right stats to pull is a big part of it. Any tips anyone has to this regard are welcome. I'll probably do some reading on how to measure I/O and then track those stats.

My favourite approach to performance trouble shooting is as described by Sunil Agarwal in Chapter 1 of Inside Microsoft SQL Server 2005 Query Tuning and Optimization, combined with the techniques outlined in:

The SQL Server 2005 Waits and Queues Best Practices Article.

and

Troubleshooting Performance Problems in SQL Server 2008

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi