| Author |
Topic |
|
rohitmathur11
Yak Posting Veteran
77 Posts |
 Posted - 2009-11-24 : 05:10:52
|
| we can start profiler from management studio on server site..but want to know can we start profiler from sql server 2005 cilet ..which i installed in my desktop ..? Like i will connect to server and then database ..after can i start profile on this database ..? Thanks |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-11-24 : 07:39:38
|
| yes -- you can run profiler on a client. Just point it at the serverCharlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
rohitmathur11
Yak Posting Veteran
77 Posts |
Posted - 2009-11-25 : 01:39:59
|
| Thanks for reply.On my desktop sql server 2005 cilent is installed but after connecting to server i am not able to find any option in menu bar (Tools...etc.) to start profiler...please tell me how to start it on a perticular database in this server..? |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-11-25 : 04:03:01
|
| As far as I'm aware (in my limited use of profiler) you don't perform a trace on a particular database. You perform a trace on the server as a whole.You can filter the results by connection name etc.Just start a new trace and choose the desired elements to report on.If you need to filter the results after that you can.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
rohitmathur11
Yak Posting Veteran
77 Posts |
Posted - 2009-11-25 : 07:01:35
|
| ok...i got it ..we can not run profiler for one database ..it will be for all database in the server... But i need to know that ..if u are sitting on server ..open managment stuidio ..go to Tools and run profiler..but if u r sitting on some desktop machine where only sql server client is installed for just connecting to server ...in this management studio is not displaying run profiler option in the Tools menu..then how to run it from client ..because i m not having user name from server machine ...i can conn. to database with DBA privi. |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-11-25 : 07:17:20
|
| Mine is inStart - > programmes -> Microsoft SQL Server 2005 -> Performance Tools -> SQL Server ProfilerMaybe you didn't install it as part of your client tools?Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
rohitmathur11
Yak Posting Veteran
77 Posts |
Posted - 2009-11-25 : 08:06:07
|
| Yes..for me " -> Performance Tools -> " is not comming ..as well as "Tools -> Profilre " Is there any other way..? |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-11-25 : 08:36:43
|
| It's probably not installed on the client machine.You could do a search for the file PROFILER90.exe. If that doesn't exist then you obviously didn't install it.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
rohitmathur11
Yak Posting Veteran
77 Posts |
Posted - 2009-11-26 : 01:07:31
|
| Ok..i will check it..Thanks a lot |
|
|
|
|
Sql server Profiler