Posted
by Danilo Brambilla
on Server Fault
See other posts from Server Fault
or by Danilo Brambilla
Published on 2010-05-11T16:05:47Z
Indexed on
2010/05/11
16:14 UTC
Read the original article
Hit count: 262
Hi,
does SQL Server Profiler continue to profile also if I close the program and log out from the RDP session?
Thank you all for help
© Server Fault or respective owner
as seen on Stack Overflow
- Search for 'Stack Overflow'
Does SqlServer has to start a Scan to execute a stored procedure?
In Sql Profiler I can see this:
RPC Starting ( exec sp_Edu3_SelectExamSession @ExamSessionId=N'AccessCode39361814' )
Scan:Started
Scan:Started
Scan:Started
RPC Completed ( exec sp_Edu3_SelectExamSession @ExamSessionId=N'AccessCode39361814'…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
i've picked a query out of SQL Server Profiler that says it took 1,497 reads:
EventClass: SQL:BatchCompleted
TextData: SELECT Transactions....
CPU: 406
Reads: 1497
Writes: 0
Duration: 406
So i've taken this query into Query Analyzer, so i may try to reduce…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
If in SqlProfiler you can see that to execute a query a Scan is Started, does this mean a full table scan or can it just be a lookup? If it can be both, how can you tell which one of the two it is?
>>> More
as seen on Dot net Slackers
- Search for 'Dot net Slackers'
In this article we will be taking a look at the new LINQ to SQL Profiler from HibernatingRhinos. This tool gives you a view into the goings on of LINQ to SQL. Not only does it allow you to see the SQL that is generated by your LINQ queries but it also shows you information about your connections…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Suppose that I try to insert some data into a table and if the insertion fails due to some CDBException, will that be logged in to the SQL Profiler logs?
I am using SQL Server MSDE 2000
>>> More
as seen on Server Fault
- Search for 'Server Fault'
We would like to detect what devices & what programs users are using to connect to the Windows 2008 R2 Remote Desktop. In particular, we would like to have an ability to detect the remote devices such as iPads, iPhones & Androids, identify the software used and allow these connections only…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
When I reboot a Windows 2003 or Windows 2008 server via a Remote Desktop connection, the server comes back up and will not accept any RDP connections: the RDP client errors out with "Connection Refused."
The Terminal Services service is running on the server and restarting it has no effect. No errors…
>>> More
as seen on Ask Ubuntu
- Search for 'Ask Ubuntu'
Here is the Problem: I have two computers connected in the same LAN.
I am trying to access one computer from another using Remote Desktop Viewer, I am able to see the remote desktop.
But when i click on any thing or perform any action, I dont see the result but the action is performed on the remote…
>>> More
as seen on Super User
- Search for 'Super User'
Sometime ago, I used carbon copy as I was replacing my hard drive in my Mac Mini running Snow Leopard. Afterwards, on my new drive I had some permission problems.
I've tried several times running a repair permissions / repair disk from disk util. It shows that there are problems and I think it says…
>>> More
as seen on How to geek
- Search for 'How to geek'
iPads and Android tablets can’t run Windows apps locally, but they can access a Windows desktops remotely — even with a physical keyboard. In a pinch, the same tricks can be used to access a Windows desktop from a smartphone. Microsoft recently launched their own official Remote Desktop…
>>> More
