.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

sql server Architecture internals 2

Posted By:      Posted Date: October 24, 2010    Points: 0   Category :Sql Server
 

Please can someone explain the different Buffer and Cache structures in SQL Server.

How they relate and if the cache is at SQL Server Storage Engine Level or at a SQLOS Level or is it like a Namedspace on the Hard Drive or on Memory?

Is there a diagram that can help elucidate their interaction. Thank you.




View Complete Post


More Related Resource Links

SQL SERVER ARCHITECTURE INTERNALS

  

Can someone point out a diagram that explains how the sql server architecture is layed out? Not how the different components such as SSMS, SSIS, SSAS and SSRS are related, BUT HOW THE INSTANCE RELATES TO THE PROCESS LAYER AND WHAT ALL COMPONENTS ARE WITHIN ITS MEMORY LAYER, HOW ITS DIFFERENT COMPONENTS TALK TO THE DATAFILES, LOGFILES, CONFIG FILES AND SUCH.

In oracle, we have indepth documentation ON THE ARCHITECTURE, HOWEVER, ON SQL SERVER I DON'T SEEM TO FIND ANY. In my opinion, this is the most important kernel that needs to be understood. PLEASE HELP. 


sql server Architecture internals 3

  

Can someone please explain the following in detail and how they relate? Thank you!

1•procedure cache

2•worker threads/pool/states

3•connection threads/pool/states

4•The Ghost

5•other static threads/processes

6•SQL Service vs. Windows

7•SQL Agent

8•perfmon hooks


BizTalk Server 2000: Architecture and Tools for Trading Partner Integration

  

This article provides an overview of the concepts involved with implementing a trading partner integration system on BizTalk Server 2000 and details the document interchange server architecture and toolset. Additionally, an early look was taken at some business process integration features planned for the production release of the product that allow easy design, execution and sharing of new business processes with trading partners. The concepts and architecture presented allow companies to prepare internal line-of-business applications and trading partners for systems that improve customer service and reduce operating costs.

Aaron Skonnard and Bob Laskey

MSDN Magazine May 2000


Questions on Multi-Tenant Data Architecture for SQL Server Database and ASP.NET application

  
My company wants me to make the same asp.net application and sql server database be sharable amongst different clients. Clients will use the database for their own business use, will have their own data, we will have our own data. How can I share the same SQL Server database amongst different clients having same ASP.NET application (but somehow be able to differentiate which client user is logging in) ? Do I need to use ApplicationID and how will I detect at login which one to use ? I know I will need to add another field in all tables to differentiate client's data from ours.  

Extract x86 architecture from SQL Server 2008 R2 media

  

Hi all,

 

In order to distribute my application, I need to put inside its media SQL Server 2008 R2 Workgroup, but the whole media is too large.

Is there a way to "extract" only the x86 architecture setup from the media?

I have tried launching directly DVD:\x86\setup100.exe but I got an error that says to execute setup.exe from the parent folder...

 

any help appreciated.

 

Luca


Luca

Upgrade of SQL Server 2008 x64 Developer to 2008 R2 x64 developer fails - upgrade architecture misma

  

I'm trying to upgrade a SQL Server 2008 x64 Developer install to a 2008 R2 x64 Developer Install. Just before it actually upgrades, one of the upgrade rules fails - upgrade architecture mismatch.

Is there a way to check what is really causing this failure, so that it can be overcome?

Thank you.


Architecture help for server/multi-client two-way messaging and MVVM scenario

  

There looks like heaps of information on WCF which is kind of my problem. I'm unsure of what I should be reading and can't afford to spend days reading to whittle down my options to what I really need. So I'm hoping for a brief nudge in the right direction please!

I'm building an app that is TCP server/client scenario:

  • Messages need to be sent from either client or server based on events raised at either end
  • Messages could be from client-server or client-client
  • I need some peer-to-peer content distribution (file sharing/copying)
  • Some messages need to go through reply/response - being initiated at either end
  • Some messages/requests need to last past network interrupts/reboots. I.e. request from client that requires manual user action on the server end, resulting in reply back to client at a later date

Some comments on what WCF architecture/technology choices would best fit these needs would be very welcome :)

Also, I'm using MVVM architecture. Should the viewmodel/business logic know about WCF classes or should the model take care of contracts, etc? Or in other words, where should the viewmodel and model separate in WCF? Some examples of appropriate method names at the business logic level and model level would help :)

Anyway, thanks for reading, now back to the books :)


about architecture of SQL Server Cursors and inside SQL server cursors process mechanism

  

Hi all,

I need some information about architecture of SQL Server Cursors and inside mechanism of SQL Server Cursors,

My Information

·         IM using SQL SERVER 2005 and 2008

·         CURSOR TYPE - READ_ONLY

Ex: DECLARE

Architecture Tools in VSTS 2010

  
Designing new functionality on existing applications can be daunting. There are always differences between the original design and the current implementation.

The new Architecture tools within Visual Studio Team System 2010 help you understand the application you have, design new functionality you need, and validate that your design and your implementation do not deviate.

SharePoint Tutorial - SharePoint Logical Architecture

  
The SharePoint logical architecure consists of nested and isolated levels. These levels provide benefits for security, navigation, search, branding and ect. depending on the level

SharePoint Farm
The base level for any SharePoint implementation is the SharePoint farm. Physically a farm can consist of one server or many servers. An organization may implement one or more farms. This usually depends on security and performance needs.

SharePoint Tutorial -SharePoint Physical Architecture

  
The SharePoint physical architecture consists of services running on one or more servers.

Services
There are three types of services that together run the SharePoint farm: web, application and database services. Web services through Internet Information Server is what processes the ASP.Net and sends back the html to a user's browser. Application services is where the "brains" of SharePoint are located. All of the SharePoint specific logic and services are processed there. Database services are run by SQL Server and it's where all the data/content for SharePoint is stored.

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Making Ajax Callbacks to the Server Using jQuery with ASP.NET

  
In the first part of this article series I introduced jQuery's functionality and how it provides a rich client side programming model. This time around I'll expand on these concepts and show you how you can use jQuery in combination with ASP.NET using it as an AJAX backend to retrieve data. I'll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in WebForms.


jQuery is just a JavaScript library so it will work seamlessly with ASP.NET both from page code as well as through backend driven code using the Page.ClientScript object or ScriptManager. You can use jQuery on its own as a client side and Ajax library that communicates with ASP.NET or you can use jQuery in combination with ASP.NET AJAX. The two actually complement each other quite well as jQuery provides functionality that the ASP.NET AJAX library does not and vice versa. For the most part the interaction between the two libraries is trouble free except for a few very rare edge cases.

MS SQL Server: Disconnect Users From Database - Kill User Session

  
If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

  
We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend