Cachein sql server 2005

Question

Post reply

Cachein sql server 2005

dastagirid

SSCommitted

Points: 1810
More actions
October 15, 2008 at 12:20 am

#383086

hello,
send me any good link for how to use cache in sql server 2005.
Thank you
Dastagiri.D
Thanks
Dastagiri.D

Viewing 8 posts - 1 through 7 (of 7 total)

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

Kishore.P SSCrazy Eights Points: 8147 More actions · Answer 1

check in google.com.

Links:

http://www.google.com/search?q=how+to+use+cache+in+sql+server+2005&rls=com.microsoft:en-us&ie=UTF-8&oe=UTF-8&startIndex=&startPage=1

http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx

http://decipherinfosys.wordpress.com/2007/09/19/procedure-cache-in-sql-server-2005/

http://www.mssqltips.com/tip.asp?tip=1563

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Data cache? Procedure cache?

What do you want to know about it?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

dastagirid SSCommitted Points: 1810 More actions · Answer 3

hello,

I need data cache and procedure cache.

Thanks

Dastagiri.D

Thanks
Dastagiri.D

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

What do you want to know about them?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

dastagirid SSCommitted Points: 1810 More actions · Answer 5

hello,

I want data from database but each time I need data I want to go to database and get data.So I want to reduce this attacking each time with database.

Send me any source code for data cache and Procedure cache.

how to impliment in my project works.I need information lot about this topice.

Regards:

Dastagiri.D

Thanks
Dastagiri.D

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

There's a big, big difference between SQL's internal caches (which is what Kishore and I were talking about) and client-side caching

What front end language are you using?

You may get better answers on client-side caching from an appropriate developer forum. It's not a SQL Server topic.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

homebrew01 SSC Guru Points: 55548 More actions · Answer 7

Is he asking about pinned tables ?

From BOL 2005

This functionality was introduced for performance in SQL Server version 6.5. DBCC PINTABLE has highly unwanted side-effects. These include the potential to damage the buffer pool. DBCC PINTABLE is not required and has been removed to prevent additional problems. The syntax for this command still works but does not affect the server.