Viewing 15 posts - 1 through 15 (of 76 total)
The Extended Event that used is based on an entry at Brent Ozar by Erik Darling ( https://www.brentozar.com/archive/2015/12/tracking-tempdb-growth-using-extended-events/ ). I modified it to suit my purposes and it...
March 24, 2016 at 10:02 am
I know and I thank you for that. But I was trying to avoid that. I do appreciate your help. I didn't mean to come as I didn't really appreciate...
March 22, 2016 at 10:44 am
I started extended events session to capture that file size change. That would be more to the point than a profiler trace.
March 22, 2016 at 9:23 am
Profiler would have to be filtered at the most because it is an auditing application and it captures too much data.
Thanks
March 22, 2016 at 9:07 am
That didn't work. I think you are right and the reason it is not letting me unlock him is because of all those sessions logged in from different hosts.
Thanks
October 22, 2014 at 1:08 pm
We got it working partially. It works with IP,port, although there are some issues with some servers that don't seem to connect that way, but not with names. The problem...
September 23, 2014 at 3:01 pm
Yes, unfortunately our network group takes a long time to respond. I have a meeting today with systems who still thinks it is a SQL issue but that is largely...
September 23, 2014 at 7:34 am
That didn't make a difference at all. What I did find though was that the server was accessible, painfully slow, from the old server in a different network across the...
September 22, 2014 at 2:54 pm
I just noticed one thing, this server was cloned from one outside our network and the accounts for SQL carried over. I am working with the sysadmin out of suspicion...
September 22, 2014 at 9:47 am
Yes, it is but under a different account than SQL Server. Does that make a difference?
September 22, 2014 at 9:27 am
I did check the ports and tried accessing to no avail. I have contacted my sysadmin to look into it.
Thanks
September 22, 2014 at 9:10 am
From the server I have no problem accessing the instances. It is when someone attempts a remote access to either one of them that the error occurs. Pinging the server...
September 22, 2014 at 4:52 am
Thanks, Andrew, but I already did that and it is still not reachable.
September 19, 2014 at 9:46 am
Thanks, I will check the results from your queries.
August 13, 2014 at 6:43 am
Viewing 15 posts - 1 through 15 (of 76 total)