Viewing 15 posts - 11,566 through 11,580 (of 49,552 total)
Degree of parallelism 0 doesn't mean it actually ran in parallel, Are you seeing parallel-specific query operators?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 25, 2013 at 9:11 am
Nothing in there that could throw that error. What's the entire of job step 3?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 25, 2013 at 5:40 am
Viewing 15 posts - 11,566 through 11,580 (of 49,552 total)