APIs for SQLServer state storage

Kishore Gopalan

Hi,
Is there a set of APIs that would let me access the tables where ASP.NET
stores the state when in SQLServer mode.

Thanks.

Kishore

Nov 18 '05 #1

Subscribe Reply

1274

DWinter

I'm assuming you mean you are storing your session state in sql server and
not using a session server or inproc memory. If this is the case, then any
API you have to access a sql server database will do. Query Analyzer, or
even MS Access if you create a connection to the SQL database. Eventhough
the ASPState (or whatever you called it) that suppose to store the session
information appears it should be in that database, it is actually stored in
the tempdb. Look in the tempdb database of the server handling your session
state and you will find all your session data there.

D.

"Kishore Gopalan" <Kishore Go*****@discuss ions.microsoft. com> wrote in
message news:99******** *************** ***********@mic rosoft.com...

Hi,
Is there a set of APIs that would let me access the tables where ASP.NET
stores the state when in SQLServer mode.

Thanks.

Kishore

Nov 18 '05 #2

Edward

Storing the state in tempdb is fine, but you lose information when the
sqlserver is restarted. You can also store the state information in a
seperate database. See
http://support.microsoft.com/default...b;en-us;311209

"DWinter" wrote:

I'm assuming you mean you are storing your session state in sql server and
not using a session server or inproc memory. If this is the case, then any
API you have to access a sql server database will do. Query Analyzer, or
even MS Access if you create a connection to the SQL database. Eventhough
the ASPState (or whatever you called it) that suppose to store the session
information appears it should be in that database, it is actually stored in
the tempdb. Look in the tempdb database of the server handling your session
state and you will find all your session data there.

D.

"Kishore Gopalan" <Kishore Go*****@discuss ions.microsoft. com> wrote in
message news:99******** *************** ***********@mic rosoft.com...
Hi,
Is there a set of APIs that would let me access the tables where ASP.NET
stores the state when in SQLServer mode.

Thanks.

Kishore

Nov 18 '05 #3

Similar topics

2370

Size of SQLServer databases with indices

by: Bart Torbert | last post by:

Hello, I am starting to examine using SQLServer instead of Oracle. I went through the SQLServer import utility to copy tables from Oracle into SQLServer. I then checked the size of the database. I then started to specify indices for the tables. I did not see the database file size grow all that much. I kept on using the shrink command to make sure that wasted space was removed. I even made sure that minimal free space was allowed.

Microsoft SQL Server

2463

session state - SqlServer

by: quique | last post by:

Hi all, I want to know the advantages and disadvantages of the methods of maintain session state, obviously if i choose sqlserver is the most robust but the less performace.. If wan't to maintain session state in sqlserver, Does anybody knows when it's saved to database?, on beguinSession, on endSession... <sessionState

ASP.NET

4007

SQLServer session state performance issues

by: John Q. Smith | last post by:

I'm trying to find out some of the details behind OOP state management with SQL Server. For instance - how long does the session object live on any server? Is it created and destoyed with each page request? - will each reading of a session variable cause a round trip to the DB server? or does the complete session live within the HttpContext object? - when asp.net session state is enabled (in any mode), after a session has been created,...

ASP.NET

2690

SQLServer Session State

by: Julie Barnet | last post by:

Hi, I am having a problem with my session state through sql server. This used to work, then all of a sudden (the only change was setting up replication in the sqlserver database) it stopped working. I ran uninstallsqlstate.sql after stopping w3svc and then restarted the w3svc and rean installsqlstate.sql. This works fine on my machine and my session variables work again....but I'm an administrator on the database. I go to another...

ASP.NET

1827

SQLServer Session storage and multiple sites

by: Dave Wright | last post by:

Hi, We have implemented a IIS NLB farm and would like to know if a SQL Session database can be used to host multiple sites? As the entry in web.config does not allow a database name to be specified it would mean either multiple instances / servers if more than 1 site needed to store session in a SQL database. As such I am guessing it will work but I would like to confirm this. Any info would be great

ASP.NET

8420

Session_End and SqlServer Session Mode

by: karahan celikel | last post by:

I realized that when SqlServer mode is used for session management Session_End event is not fired in global.asax. What can I do if I want to do something when a user's session end? Thanks

ASP.NET

2187

hi-traffic websites & session-state

by: John A Grandy | last post by:

for high traffic public websites , what are the proven options for session-state storage & management ? is an out-of-process state-server generally preferred over a sql-server ? what are the relevant criteria ? is the primary criteria max expected total storage size (for all active sessions) versus max ram available on the state-server machine ? if ADO.NET objects (such as small DataTables) must be stored in session-state , is any...

ASP.NET

1233

State Management

by: Richard | last post by:

Can collection classes be used to store session data? In a couple of books on ASP.Net where they discuss state management (to capture a user's input data), they talk about session and application objects, cookies, statebag, etc. But if I have a checkboxlist, can't I just iterate through the selected items and store them in a collection class for use in later pages in the web app? Would there be implications of doing it this way? Thank...

ASP.NET

2231

sqlserver 2005: indexes on raid-0?

by: boa | last post by:

I'm currently planning disk layouts and use for a new version of our database. The current version has all data and indexes in the default filegroup, placed on one big raid-5 array(6 drives) along with the transaction log. Performance is not the best, as you may imagine... Next week we will add another 14 drives and organize them in different combos of raid-10 and raid-1, and then create several filegroups and place tables and index data...

Microsoft SQL Server

9602

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10237

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10071

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10017

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

7431

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5326

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5467

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3987

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3589

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP