maintenance required?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rodchar - 20 Jul 2006 15:42 GMT

hey all,
i just configured my sql server to be the session state for my web page for
the first time (under fw v.1.1 ).

is there any maintenance involved when using sql server as session state?
for instance, do i have to clear tables every now and then?

thanks,
rodchar

Reply to this Message

Furqan Baqai - 22 Jul 2006 09:58 GMT

Havent used it in any commercial project but i think it would be a good idea
to presiodically re-create the index using DBCC
Syntax:
dbcc dbreindex('Table','IndexName | Leave wmpty if you wana recreate all
index associated with the table>',Fill Factor | make it 0 if you dont wana
change the fill factor);

You can also define a mainteance plan for it as well using Mainteance wizard

Signature

Mohammad Furqan Baqai
MCAD

> hey all,
> i just configured my sql server to be the session state for my web page for
[quoted text clipped - 5 lines]
> thanks,
> rodchar

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...