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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Export/Import SQL Table cache?

Author  Topic 

raysefo
Constraint Violating Yak Guru

260 Posts

Posted - 2013-02-11 : 02:19:48
Hi,

I have sql server 2008 and on one of it's database I have table caching. Now this database should run on another server. So I wonder if we export this database and import it on the new server, do I have to reconfigure table caching? Any ideas?

Best regards.

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-02-11 : 09:08:14
How did you enable table caching? I am asking because I am not familiar with any setting in SQL 2008 that would allow you to specify that a table be cached. There was a DBCC PINTABLE in old versions of SQL, but that has been deprecated in SQL 2008. Is there an equivalent in SQL 2008? Or is it some other command/setting that you are using?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-02-11 : 10:33:06
I've heard DBCC PINTABLE to be problamatic and been told to avoid it in most occasions

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-02-11 : 10:51:43
Visakh, that has been my impression too. If a table is pinned in the buffer pool and the table continues to grow, it can have BAD consequences. I recall reading that, for this and other reasons, even though the command exists in SQL 2008, it does nothing at all. SQL Server takes your pintable requests, and silently throws into the garbage bin and makes funny faces at you for having made that request.

In any case, raysefo might be talking about something else completely different.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-02-11 : 23:08:23
quote:
Originally posted by James K

Visakh, that has been my impression too. If a table is pinned in the buffer pool and the table continues to grow, it can have BAD consequences. I recall reading that, for this and other reasons, even though the command exists in SQL 2008, it does nothing at all. SQL Server takes your pintable requests, and silently throws into the garbage bin and makes funny faces at you for having made that request.

In any case, raysefo might be talking about something else completely different.


I also hope so
Thanks for the confirmation

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

raysefo
Constraint Violating Yak Guru

260 Posts

Posted - 2013-02-12 : 01:48:26
Hi,

Here is how I used SQL caching;

http://www.dotnetfunda.com/articles/article1382-how-to-implement-sql-caching-in-aspnet-poll-based-sql-cache-dependency.aspx
Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-02-12 : 08:06:25
This is really client side caching.

I tried out the walk through described on this page: http://msdn.microsoft.com/en-us/library/e3w8402y(v=vs.90).aspx When you do that, it creates a trigger on the table of interest. In my case, the table is called MyTest and a trigger on it for INSERT, UPDATE, and DELETE was created with the name MyTest_AspNet_SqlCacheNotification_Trigger. (Also a bunch of tables and stored procs).

So, then the question is whether if you backed up this database and installed on a new server, would the caching setup automatically port and be useable? I don't know the answer, but my sense is that it won't. I would have liked to test that as well, but time constraints.

While my response is absolutely of no use to you, I learned something new. So thank you for asking the question. If you do find the right answer, would you post back so all can learn?
Go to Top of Page
   

- Advertisement -