339 reputation
113
bio website
location
age
visits member for 2 years, 1 month
seen 7 hours ago

Born in Whitby, cricket follower, player and skipper @NewRoverCC, IT geek, and average company!


11h
comment Kerberos and Linked Server
I have go the service account and computer objects changed to Trust this user for delegation to any Service (Kerberos only) and I still get the failed Anonymous Login problem.
1d
comment Kerberos and Linked Server
OK I will get the delegation added and see how it goes.
1d
revised Kerberos and Linked Server
added 184 characters in body
1d
asked Kerberos and Linked Server
1d
accepted CXPACKET SUSPENDED and NULL wait type
Mar
27
comment CXPACKET SUSPENDED and NULL wait type
I see, I still would have expected a wait type of some sort to have appeared in the thread doing some work though? Also whats the best way to balance the workload then, by just ensuring that you have a good indexing strategy?
Mar
26
asked CXPACKET SUSPENDED and NULL wait type
Mar
13
asked Run SSIS Package as different user
Feb
18
awarded  Popular Question
Jan
23
awarded  Popular Question
Jan
14
revised Proxy Account SSIS and NETWORK SERVICE
added 416 characters in body
Jan
14
revised Proxy Account SSIS and NETWORK SERVICE
added 226 characters in body
Jan
14
asked Proxy Account SSIS and NETWORK SERVICE
Oct
30
comment Wait Stats, Server Up Time and CXPACKET
@Aaron CXPACKET waits are taking up %78 of the total waits and second is LATCH_EX taking up %9. In regards to knowing if I have a performance problem, I don't know really as I haven't had any complaints from end users, when would you consider there to be an issue when looking at waits? I was trying to work out waits against server up time to determine if the system was waiting more than it was "doing work", but thats where my initial question arose. I will do a search of the plan cache to look for specific parallel plans.
Oct
30
comment Wait Stats, Server Up Time and CXPACKET
My current MAXDOP is 0 and cost threshold is 5 (I know its low but how do I determine a good number?)
Oct
29
asked Wait Stats, Server Up Time and CXPACKET
Oct
24
asked Replication Snapshot folder not cleaning up
Oct
24
answered Machine account causing a Token-based server access validation failed with an infrastructure error
Oct
24
asked Machine account causing a Token-based server access validation failed with an infrastructure error
Oct
7
comment TempDB Log Space and ACTIVE_TRANSACTION
I stupidly ran the CHECKPOINT so now have NOTHING as the log_reuse_wait_desc. In terms of the space its 1GB chunks and 26GB left. I tried to use sys.fn_trace_getinfo to find any auto growths but didn't find any which is also confusing.