Viewing 15 posts - 42,166 through 42,180 (of 49,562 total)
Bilichi (12/22/2008)
Replication is configured in Production only and not in my Development server.
Since that's a backup of a database that's replicated, there's replication set up in it as well. Create...
December 23, 2008 at 1:07 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic624449-5-1.aspx
December 23, 2008 at 1:05 am
jmohan_it (12/23/2008)
Any one can tell. what ia a breakpoint in ssis? How is it setup? How do you disable?
Have you looked through Books Online, specifically the sections on SSIS?
December 23, 2008 at 1:03 am
Not without a trace running. (profiler/server-side)
December 23, 2008 at 1:02 am
Someone's enable the query governor on the database, and set the threshold for 300. Speak to the DBA who looks after that server.
December 23, 2008 at 1:01 am
leonp (12/22/2008)
I meant to say I am seeing a lot of sessions with a 100% writer thread stats for this DB
Doesn't mean you have IO bottlenecks on the database server....
December 23, 2008 at 12:54 am
Pavas Malviya (12/22/2008)
Thank you for all the information...I think I need to use the extended proc
How's your C++ skills?
December 23, 2008 at 12:44 am
ramadesai108 (12/22/2008)
I still have a cursor
Why?
See my edited post above.
December 22, 2008 at 3:02 pm
ramadesai108 (12/22/2008)
Isn't it easier to use the 2 inserts based on the cursor values rather than doing a select as Gail pointed out?
Easier? Maybe. Slower? Definitely.
Also that update is running...
December 22, 2008 at 2:54 pm
leonp (12/22/2008)
Meanwhile, heres the question again, if these numbers look good, what is with the low PLE - 200.76?
Good question. The buffer cache hit ratio's high, so most pages SQL...
December 22, 2008 at 2:48 pm
I can't see any indications of poor IO performance from those stats.
December 22, 2008 at 2:32 pm
DBASkippack (12/22/2008)
We inadvertantly had 6 DB's DROPPED from a non-prod environment. How can I tell who (or what process) dropped them?
If you didn't have some trace running at the...
December 22, 2008 at 2:31 pm
Why are you using a cursor at all? The update doesn't reference the cursor row, meaning you're doing exactly the same update multiple times.
The two inserts can be done...
December 22, 2008 at 2:27 pm
HKwai (12/22/2008)
December 22, 2008 at 9:32 am
John (12/22/2008)
I was wondering if some form of a detach / re-attach would work from the other log shipped standby server at C.
Unfortunately not.
If you try to detach an...
December 22, 2008 at 9:28 am
Viewing 15 posts - 42,166 through 42,180 (of 49,562 total)