January 25, 2010 at 2:25 pm
Hi
Currently i have been told i cannot go for any tools to monitor my server. All i have is only the SQL Management Studio. I know i can use SQL Profiler but how do i use the SQL Profiler to trace sessions which hang when i do a bulk data load using scripting? I am using Trxn.Replication to replicate lot of data from Server A to Server B; Once in 3 days the replication pull job hangs and it gives "The process is running and is waiting for a response from the server.", "Query timeout".
Inputs would be appreciated.
January 26, 2010 at 1:40 am
There's actually quite a lot of free stuff available for monitoring if you have a search, and writing your own stuff isn't too difficult - there are some examples on my blog and web site and when i finish writing up the presentation I did for the UK SSUG, I will be posting how to create your own dashboards, alerts and such for real time monitoring of sql server - look out for my posts on "How are my servers today".
It sounds however like your problems might be with a thrid aprty application and that can be more tricky - the vendor should be able to help you - for free - and should at least be able to give you pointers on where to look.
You may have a network issue - set up a ping test to make sure it's not this..
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
January 26, 2010 at 1:41 am
sorry - should have said that any timeout messages are usually a client issue not a server issue.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
January 26, 2010 at 7:48 am
One thing you can use to look at "hung" processes is to go after the dynamic management view sys.dm_exec_requests. This will show you the active processes in the server including the last thing that they were waiting on, which, can really help on processes that appear stuck.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply