handles and threads

Whats the difference between handles and threads ?
Also in the performance tab in Task manager , can someone explain the
meanings of each of those different values captured under totals, commit
charge, kernel memory and physical memory
Thanks
A handle is a reference to something... Sometimes it may be a reference to
a file, or an object..... Perhaps you wish to open a file and the file open
gives you a handle to the file... ( a reference to it) which you store in a
variable, and use the variable to reference the file for reading/writing.
etc.
A thread is an individually schedulable piece of work... A program( or
process) always has at least one thread. A program ( like SQL) may fire off
many threads, which work co-operatively or independently. This is called
multi-threading... When a program has multiple users ( like SQL),
multi-threading allows mulitple users to get work done at the same time...
A similar example might be a single lane road going up a mountain, with an
18 wheeler at the front of the line... No one can make more progress than
the 18 wheeler... If there were multiple lanes on the road ( equivalent to
multiple threads in an application), the others would not be blocked or
slowed down by the 18 wheeler...
Although someone else might do a better job on the task manager part... I'll
give it a stab..
Physical memory is the actual physical memory on the computer... Windows
however can act as if there were more memory available than what is
physically on the box (virtual memory). How much virtual memory is used ( I
beleive) is commit charge... Kernel memory is how much memory the OS is
using.
If you run Task Manager, select help, and on the search tab type "commit
charge". You will be taken to a window that has a short description of the
meanings as well.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ekX1i35cEHA.3792@.TK2MSFTNGP09.phx.gbl...
> Whats the difference between handles and threads ?
> Also in the performance tab in Task manager , can someone explain the
> meanings of each of those different values captured under totals, commit
> charge, kernel memory and physical memory
> Thanks
>

handles and threads

Whats the difference between handles and threads ?
Also in the performance tab in Task manager , can someone explain the
meanings of each of those different values captured under totals, commit
charge, kernel memory and physical memory
ThanksA handle is a reference to something... Sometimes it may be a reference to
a file, or an object..... Perhaps you wish to open a file and the file open
gives you a handle to the file... ( a reference to it) which you store in a
variable, and use the variable to reference the file for reading/writing.
etc.
A thread is an individually schedulable piece of work... A program( or
process) always has at least one thread. A program ( like SQL) may fire off
many threads, which work co-operatively or independently. This is called
multi-threading... When a program has multiple users ( like SQL),
multi-threading allows mulitple users to get work done at the same time...
A similar example might be a single lane road going up a mountain, with an
18 wheeler at the front of the line... No one can make more progress than
the 18 wheeler... If there were multiple lanes on the road ( equivalent to
multiple threads in an application), the others would not be blocked or
slowed down by the 18 wheeler...
Although someone else might do a better job on the task manager part... I'll
give it a stab..
Physical memory is the actual physical memory on the computer... Windows
however can act as if there were more memory available than what is
physically on the box (virtual memory). How much virtual memory is used ( I
beleive) is commit charge... Kernel memory is how much memory the OS is
using.
If you run Task Manager, select help, and on the search tab type "commit
charge". You will be taken to a window that has a short description of the
meanings as well.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ekX1i35cEHA.3792@.TK2MSFTNGP09.phx.gbl...
> Whats the difference between handles and threads ?
> Also in the performance tab in Task manager , can someone explain the
> meanings of each of those different values captured under totals, commit
> charge, kernel memory and physical memory
> Thanks
>

handles and threads

Whats the difference between handles and threads ?
Also in the performance tab in Task manager , can someone explain the
meanings of each of those different values captured under totals, commit
charge, kernel memory and physical memory
ThanksA handle is a reference to something... Sometimes it may be a reference to
a file, or an object..... Perhaps you wish to open a file and the file open
gives you a handle to the file... ( a reference to it) which you store in a
variable, and use the variable to reference the file for reading/writing.
etc.
A thread is an individually schedulable piece of work... A program( or
process) always has at least one thread. A program ( like SQL) may fire off
many threads, which work co-operatively or independently. This is called
multi-threading... When a program has multiple users ( like SQL),
multi-threading allows mulitple users to get work done at the same time...
A similar example might be a single lane road going up a mountain, with an
18 wheeler at the front of the line... No one can make more progress than
the 18 wheeler... If there were multiple lanes on the road ( equivalent to
multiple threads in an application), the others would not be blocked or
slowed down by the 18 wheeler...
Although someone else might do a better job on the task manager part... I'll
give it a stab..
Physical memory is the actual physical memory on the computer... Windows
however can act as if there were more memory available than what is
physically on the box (virtual memory). How much virtual memory is used ( I
beleive) is commit charge... Kernel memory is how much memory the OS is
using.
If you run Task Manager, select help, and on the search tab type "commit
charge". You will be taken to a window that has a short description of the
meanings as well.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ekX1i35cEHA.3792@.TK2MSFTNGP09.phx.gbl...
> Whats the difference between handles and threads ?
> Also in the performance tab in Task manager , can someone explain the
> meanings of each of those different values captured under totals, commit
> charge, kernel memory and physical memory
> Thanks
>

hand under database icon

Hi,
How do I disable the "hand" icon right under the database icon in sql
enterprise manager?
ThanksThe "hand" indicates that the database is enabled for replication. If you
need replication, you cannot remove the hand. If you don't need
replication, look in BOL under "Replication". You will find numerous ways
to remove replication from specific articles all the way to removing it from
the server entirely. Come to think of it, look in BOL under "Replication"
either way. You will need to know about it if you intend to keep it.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"mecn" <mecn2002@.yahoo.com> wrote in message
news:eh0A8CfIGHA.216@.TK2MSFTNGP15.phx.gbl...
> Hi,
> How do I disable the "hand" icon right under the database icon in sql
> enterprise manager?
> Thanks
>|||Go to Tools, Replication, Configure Publishers, Distributor, Subscribers,
and in the Publication databases, uncheck the check marks beside your
database which is being shared/replicated.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"mecn" <mecn2002@.yahoo.com> wrote in message
news:eh0A8CfIGHA.216@.TK2MSFTNGP15.phx.gbl...
> Hi,
> How do I disable the "hand" icon right under the database icon in sql
> enterprise manager?
> Thanks
>

Hackes SQL Server 2000

Hi Folks,
i got hacked and the password perhaps also the username for connecting over enterprise manager was changed. Is there a possibility to get my old stuff back or to get the changed username and password ?
Please help.

Patrick

System: windows2000Server
DB: SQL 2000Q1 Is there a possibility to get my old stuff back or to get the changed username and password ? Please help. Patrick
System: windows2000Server
DB: SQL 2000

A1 Yes. One might redo the entire server using new secure passwords(then restore each user DB from backups taken well before the incident).|||Do you have any idea on how you were hacked ? How is sql used in your environment ? Do you have web access to your sql server through an asp page (a select/update/delete queries) - if so, you may have a problem with how the programmers created it - someone might be using sql injection to change things like the sa password.|||1. If you still have BUILTIN/Administrators login, you can change your EM registration properties from sa to WinAuth.

2. LDF/MDF files can be attached to other/reinstalled server. Users lost.|||Hi guys,

i have no chance to switch to winauth, it's not working.
But i still have admin rights on the Server ??!!??
I try now to copy the ldf/mdf files to another sql server to
access them. What will happen with my DTS packages ?

Patrick|||DTS is stored in system databases, probably msdb. You can also extract login names and probably passwords from master.

One good source is
http://www.sqlservercentral.com/

There are queries how to decrypt passwords, restore system databases ...

Master database can be attached to other server as MASTER2 and you can decrypt sa password from master2.dbo.sysxlogins !!!