Viewing 15 posts - 11,566 through 11,580 (of 49,562 total)
Degree of parallelism 0 doesn't mean it actually ran in parallel, Are you seeing parallel-specific query operators?
September 25, 2013 at 3:25 pm
There's your problem
exec dbo.sproc.Infmtx_003_MonthlyAR
That states that the database name is dbo, the schema is sproc and the procedure name is Infmtx_003_MonthlyAR. Since you're getting errors, that's obviously not the case,...
September 25, 2013 at 2:42 pm
anoop.mig29 (9/25/2013)
how is this carried out in mirroring , i mean where are this log files and how are they shipped
Automatically. In mirroring the log records are sent across continually.
September 25, 2013 at 12:25 pm
It's whatever you've got it set to in the forum settings (Control Panel -> Forum Settings). Mine is in Central African Time.
September 25, 2013 at 11:16 am
I'm not downloading word docs.
What is the code for 'step 3' (whatever step 3 is)? The piece that, when you run it, you get an error.
September 25, 2013 at 11:13 am
Took me about 3 viewings to get to the point I kinda understood things. Windows memory management is not simple.
September 25, 2013 at 9:46 am
AlexMcCo (9/25/2013)
So with your 200 GB tempdb .. of course it depends what your general mdf volume.. but you definitely having problem with your code.
I'm glad you can come...
September 25, 2013 at 9:11 am
Nothing in there that could throw that error. What's the entire of job step 3?
September 25, 2013 at 9:05 am
Sounds like somewhere a table/procedure is being referenced incorrectly. dbo.something.somethingelse, rather than databasename.dbo.something. Post the code?
September 25, 2013 at 8:54 am
Someone want to add a voice of reason to this?
http://www.sqlservercentral.com/Forums/Topic1493948-391-1.aspx
September 25, 2013 at 8:52 am
Bhuvnesh (9/25/2013)
gary1 (9/24/2013)
I noticed that the sql queries are causing the PLE to drop and I'm trying to find the exact queries.
If there are culprit SP then recompile...
September 25, 2013 at 8:51 am
AlexMcCo (9/25/2013)
It is more than enough to put as 50 mb each.
Really? So my TempDB, which regularly has 200GB in use should drop down to 50MB every time I restart...
September 25, 2013 at 8:43 am
kevaburg (9/25/2013)
Would it not be a best practice though in instances with lots of databases (or in general) to spread the TEMPDB files over multiple spindles?
Maybe. Maybe not. If...
September 25, 2013 at 8:39 am
LOVER OF SQL (9/25/2013)
so... in the case, it's recommend a put datafiles .mdf, .ndf and .ldf in the same disk, correct?
Maybe. Maybe not. See my earlier posts.
September 25, 2013 at 8:34 am
kevaburg (9/25/2013)
There is never an advantage to having the same files on the same drive. You would be as well having one large TEMPDB in that case.
That's not...
September 25, 2013 at 5:40 am
Viewing 15 posts - 11,566 through 11,580 (of 49,562 total)