Profiler is intrusive even if run from a separate machine. How intrusive
depends on how much data you are capturing. I have seen it bring 4 way
servers to their knees when capturing everything coming through the kernel.
Be careful and filter down to only what data you really need to capture to
solve your problem and don't leave it running for long periods of time.
Thanks,
Ralph W. Davis
*********************************************************
*** CORPORATE DBA group - Houston ***
*********************************************************
-----Original Message-----
From: Ryan [mailto:mssqldba-ezmlmshield-x81340643.[Email address protected]
Sent: Wednesday, June 29, 2005 9:50 PM
To: LazyDBA Discussion
Subject: RE: SQL Login Info...
Uday,
Run profiler on a sepereate machine doesnt impact performance "big-time",
just dont run it on the production server itself.
Ryan
Senior Database Administrator
Support and Development Services
Information Technology Division
|---------+-------------------------------------------------------->
| | "Uday Shivamurthy " |
| | <mssqldba-ezmlmshield-x50417912.[Email Address Removed] | azyDBA.com> |
| | |
| | |
| | |
| | 30/06/2005 07:56 AM |
| | |
|---------+-------------------------------------------------------->
>---------------------------------------------------------------------------
------------------------------------|
|
|
| To: "LazyDBA Discussion" <[Email address protected]
|
| cc:
|
| Subject: RE: SQL Login Info...
|
>---------------------------------------------------------------------------
------------------------------------|
Hey guys,
Please don't use profiler like a "toy" on production dbs, it affects
performance big-time. DBCC input buffer would be more specific and less
intrisive
Regards,
Uday
.....................................
Direct: +61-2-98059739
Mobile: +61-401 705907
Email: [Email address protected]
-----Original Message-----
From: Davis Ralph
[mailto:mssqldba-ezmlmshield-x46025188.[Email address protected]
Sent: Thursday, 30 June 2005 2:01 AM
To: LazyDBA Discussion
Subject: RE: SQL Login Info...
Probably only DBCC inputbuffer(spid) if they are running at the time.
Thanks,
Ralph W. Davis
*********************************************************
*** CORPORATE DBA group - Houston ***
*********************************************************
-----Original Message-----
From: PRICE MARIE
[mailto:mssqldba-ezmlmshield-x33347659.[Email address protected]
Sent: Wednesday, June 29, 2005 10:41 AM
To: LazyDBA Discussion
Subject: RE: SQL Login Info...
How can I tell what they are doing? Is there a place in the db like
with oracle. I know about sql profiler, but somehow does not do much
for me.
Marie M.Ginette Price p
Database Administrator
Pride IT Support
Waterloo Regional Police Service
200 Maple Grove Rd.
Cambridge, ON N3H 5M1
(519) 650-8500 ext 8739 office
(519) 841-2297 cell
marie.[Email address protected]
http://www.wrps.on.ca
" Alone we can do so little; together we can do so much.....Helen Keller
"
-----Original Message-----
From: Paul Schlieper
[mailto:mssqldba-ezmlmshield-x95672129.[Email address protected]
Sent: June 29, 2005 11:28 AM
To: LazyDBA Discussion
Subject: RE: SQL Login Info...
You can see who's currently connected (Management, Current Activity,
Process Info), or sp_who2. Shows login time as well as last command
time. You can turn on Auditing, that info will go into the error log.
(Server, Properties, Security). This will not give you DB access info,
tho.
P
-----Original Message-----
From: Gelston John [mailto:mssqldba-ezmlmshield-x40712267.[Email address
protected]
Sent: Wednesday, June 29, 2005 11:12 AM
To: LazyDBA Discussion
Subject: SQL Login Info...
Hi,
Is there a way to view the active logins and database access on a SQL
Server, and specifically their access history - ie: last login, etc
Is this info stored in a table somewhere?
Thanks, John
The information contained in this e-mail may be confidential and is
intended solely for the use of the named addressee. Access, copying or
re-use of the e-mail or any information contained therein by any other
person is not authorized. If you are not the intended recipient please
notify us immediately by returning the e-mail to the originator.(16b)
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
****************************************************************************
**********************
The contents of this email and any attachments are confidential.
They are intended for the named recipient(s) only.
If you have received this email in error please notify the system manager
or
the
sender immediately and do not disclose the contents to anyone or make
copies.
** scanned this email for viruses, vandals and malicious content. **
*** PRIDE Police Services ***
****************************************************************************
**********************
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Confidentiality Note: The information contained in this message, and any
attachments, may contain confidential and/or privileged material. It is
intended
solely for the person or entity to which it is addressed. Any review,
retransmission, dissemination, or taking of any action in reliance upon
this
information by persons or entities other than the intended recipient is
prohibited. If you received this in error, please contact the sender and
delete
the material from any computer.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
____________________________________________________________________________
___
Unencrypted electronic mail is not secure and may not be authentic.
If you have any doubts as to the contents please telephone to confirm.
This electronic transmission including any attachments is intended only
for those to whom it is addressed. It may contain copyright material or
information that is confidential, privileged or exempt from disclosure by
law.
Any claim to privilege is not waived or lost by reason of mistaken
transmission
of this information. If you are not the intended recipient you must not
distribute or copy this transmission and should please notify the sender.
Your costs for doing this will be reimbursed by the sender.
We do not accept liability in connection with computer virus, data
corruption,
delay, interruption, unauthorised access or unauthorised amendment.
____________________________________________________________________________
___
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Confidentiality Note: The information contained in this message, and any
attachments, may contain confidential and/or privileged material. It is intended
solely for the person or entity to which it is addressed. Any review,
retransmission, dissemination, or taking of any action in reliance upon this
information by persons or entities other than the intended recipient is
prohibited. If you received this in error, please contact the sender and delete
the material from any computer.
MS Sql Server LazyDBA home page