If you have a chance to take a look, I would be very interested in your feedback.
Is there a sample chapter available?
Click "Mark as Answer" on the post that helped you.
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
The sample chapter isn't available yet, although it's in the works. The book should be available on Kindle and Amazon's Look Inside at some point, too. The file format translations are done in batches, and take some time after the book is in print.
Is there something in particular that you're interested in? I would be happy to answer any questions, if I can.
>Is there something in particular that you're interested in? I would be happy to answer any questions, if I can.
Which version(s) of Visual Studio does it target?
Click "Mark as Answer" on the post that helped you.
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
Most of the examples are version-neutral, and should work on 2005, 2008 or 2010. The screenshots and sample code were created using 2008 (9.0.30729.1 SP), and a small number of them use features from the Team Database edition. Most of the examples should
run fine with Visual Studio Express.
How to ensure the whole table drop into buffer cache when do a
SELECT COUNT(*) query? Is there any way to know how much buffer cache is used for specific table?
How to ensure the whole table drop into buffer cache when do a
SELECT COUNT(*) query?
As with most types of caching, including the ASP.NET Cache object, this type of pre-caching should be considered a hint, rather than a guarantee. The exact results depend on a number of factors, including other activity on the server, memory pressure, available
RAM, 32-bit vs. 64-bit, etc.
However, you can get some sense of its effectiveness from SSMS by issuing a query that uses the data once before pre-caching it, and once afterwards; just be sure to flush the buffer pool in between tests.
Doggy8088
Is there any way to know how much buffer cache is used for specific table?
DBCC SHOWCONTIG will give you a pretty good idea (see page 288).
You can also see how many pages are currently being used for the buffer cache by looking at the Database pages performance counter in the Buffer Manager object. You can see the counter from perfmon, or from SSMS with the following query:
select * from master..sysperfinfo where object_name = 'SQLServer:Buffer Manager' and counter_name = 'Database pages'
For the table "ind" example in the book, DBCC SHOWCONTIG initially reports 1624 pages. On my machine, if I clear the cache and then run the query above the result starts at 189, and after several times over a minute or so it stabilises at 1394.
If I then execute "SELECT COUNT(*) from ind", and quickly run the query again, the perf counter query now reports 3026, which is a difference of 1632 -- very close to the 1624 reported by SHOWCONTIG.
As an alternative to DBCC SHOWCONTIG, you can also run "EXEC sp_spaceused 'ind'". It reports its results in KB instead of pages, but the output format might be easier to manage programmatically, if that's your goal.
RickNZ
Contributor
5233 Points
880 Posts
New book: Ultra-Fast ASP.NET
Nov 09, 2009 09:32 AM|LINK
My new book has been released:
Ultra-Fast ASP.NET: Build Ultra-Fast and Ultra-Scalable Websites Using ASP.NET and SQL Server
An eBook is also available from Apress.
If you have a chance to take a look, I would be very interested in your feedback.
Ultra-Fast ASP.NET: Build Ultra-Fast and Ultra-Scalable web sites using ASP.NET and SQL Server
My blog: http://www.12knowmore.com
TATWORTH
All-Star
72415 Points
14017 Posts
MVP
Re: New book: Ultra-Fast ASP.NET
Nov 09, 2009 08:19 PM|LINK
Is there a sample chapter available?
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
RickNZ
Contributor
5233 Points
880 Posts
Re: New book: Ultra-Fast ASP.NET
Nov 10, 2009 08:39 AM|LINK
The sample chapter isn't available yet, although it's in the works. The book should be available on Kindle and Amazon's Look Inside at some point, too. The file format translations are done in batches, and take some time after the book is in print.
Is there something in particular that you're interested in? I would be happy to answer any questions, if I can.
Ultra-Fast ASP.NET: Build Ultra-Fast and Ultra-Scalable web sites using ASP.NET and SQL Server
My blog: http://www.12knowmore.com
TATWORTH
All-Star
72415 Points
14017 Posts
MVP
Re: New book: Ultra-Fast ASP.NET
Nov 10, 2009 09:09 AM|LINK
>Is there something in particular that you're interested in? I would be happy to answer any questions, if I can.
Which version(s) of Visual Studio does it target?
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
RickNZ
Contributor
5233 Points
880 Posts
Re: New book: Ultra-Fast ASP.NET
Nov 10, 2009 10:08 AM|LINK
Most of the examples are version-neutral, and should work on 2005, 2008 or 2010. The screenshots and sample code were created using 2008 (9.0.30729.1 SP), and a small number of them use features from the Team Database edition. Most of the examples should run fine with Visual Studio Express.
Ultra-Fast ASP.NET: Build Ultra-Fast and Ultra-Scalable web sites using ASP.NET and SQL Server
My blog: http://www.12knowmore.com
RickNZ
Contributor
5233 Points
880 Posts
Re: New book: Ultra-Fast ASP.NET
Nov 24, 2009 10:53 AM|LINK
The first review of the book has been posted on Amazon (see the link in my signature).
Ultra-Fast ASP.NET: Build Ultra-Fast and Ultra-Scalable web sites using ASP.NET and SQL Server
My blog: http://www.12knowmore.com
Doggy8088
Member
41 Points
110 Posts
Re: New book: Ultra-Fast ASP.NET
Nov 25, 2009 01:04 PM|LINK
Where is the most proper place to ask questions about your book?
http://blog.miniasp.com/
RickNZ
Contributor
5233 Points
880 Posts
Re: New book: Ultra-Fast ASP.NET
Nov 25, 2009 06:36 PM|LINK
For questions of general interest, this thread is as good a place as any.
You are also welcome to send me an email. My contact details are on my site at www.12titans.net
Ultra-Fast ASP.NET: Build Ultra-Fast and Ultra-Scalable web sites using ASP.NET and SQL Server
My blog: http://www.12knowmore.com
Doggy8088
Member
41 Points
110 Posts
Re: New book: Ultra-Fast ASP.NET
Nov 27, 2009 01:12 AM|LINK
About Page 408, Cache Warm-Up:
How to ensure the whole table drop into buffer cache when do a SELECT COUNT(*) query? Is there any way to know how much buffer cache is used for specific table?
http://blog.miniasp.com/
RickNZ
Contributor
5233 Points
880 Posts
Re: New book: Ultra-Fast ASP.NET
Nov 27, 2009 03:55 AM|LINK
As with most types of caching, including the ASP.NET Cache object, this type of pre-caching should be considered a hint, rather than a guarantee. The exact results depend on a number of factors, including other activity on the server, memory pressure, available RAM, 32-bit vs. 64-bit, etc.
However, you can get some sense of its effectiveness from SSMS by issuing a query that uses the data once before pre-caching it, and once afterwards; just be sure to flush the buffer pool in between tests.
DBCC SHOWCONTIG will give you a pretty good idea (see page 288).
You can also see how many pages are currently being used for the buffer cache by looking at the Database pages performance counter in the Buffer Manager object. You can see the counter from perfmon, or from SSMS with the following query:
For the table "ind" example in the book, DBCC SHOWCONTIG initially reports 1624 pages. On my machine, if I clear the cache and then run the query above the result starts at 189, and after several times over a minute or so it stabilises at 1394.
If I then execute "SELECT COUNT(*) from ind", and quickly run the query again, the perf counter query now reports 3026, which is a difference of 1632 -- very close to the 1624 reported by SHOWCONTIG.
As an alternative to DBCC SHOWCONTIG, you can also run "EXEC sp_spaceused 'ind'". It reports its results in KB instead of pages, but the output format might be easier to manage programmatically, if that's your goal.
Ultra-Fast ASP.NET: Build Ultra-Fast and Ultra-Scalable web sites using ASP.NET and SQL Server
My blog: http://www.12knowmore.com