Viewing 15 posts - 12,151 through 12,165 (of 49,552 total)
That's normal, the file shouldn't reduce in size automatically. That suggests that log truncation is happening regularly and there's nothing wrong.
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
August 10, 2013 at 10:16 am
Did you read the articles?
Is the log growing or is the file constant at 300GB? If it's growing, what's the reason given?
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
August 10, 2013 at 1:52 am
Take a read through these
http://www.sqlservercentral.com/articles/Administration/64582/
http://www.sqlservercentral.com/articles/Transaction+Logs/72488/
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
August 9, 2013 at 3:15 pm
I wouldn't recommend changing worker threads. 0 is a good default, it shouldn't need changing. Identifying why you're running out of worker threads should be a priority.
Maybe schedule a job...
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
August 9, 2013 at 10:28 am
The error message is pretty clear, you have a column in the select clause that's not included in a group by clause, as it has to be because of the...
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
August 9, 2013 at 9:28 am
Leave the databases that you restore in compatibility mode 100.
Doesn't mean that the server's behaving entirely as if it were a SQL 2008/2008 R2, just that some T-SQL structures and...
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
August 9, 2013 at 9:27 am
dwilliscp (8/9/2013)
We are running 2008 R2 Standard, two CPU's with 6 cores each.
32 bit or 64 bit?
Have you enabled remote DAC? If not, you'll have to connect from the server...
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
August 9, 2013 at 7:47 am
berniesprouster (8/9/2013)
However, we don't have licensing for Ent edition, so I think that may restrict the options of partitioning.
Partitioning for what?
1000 DBs is possible (limit is 32 767), but that's...
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
August 9, 2013 at 3:01 am
berniesprouster (8/9/2013)
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
August 9, 2013 at 2:58 am
There is nothing about simple recovery model that means it won't use the full size of the log or grow the log. Simple recovery only means that log truncation occurs...
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
August 9, 2013 at 2:56 am
After the restart, the DB will either be entirely available or you'll get errors in the errorlog on startup (and possibly even the DB not coming online). If the latter,...
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
August 8, 2013 at 1:37 pm
Restart SQL or take that DB offline and bring it back online (make absolutely sure the files really are there first). Once SQL detects that a file is missing, it...
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
August 8, 2013 at 1:27 pm
Please note: 4 year old thread.
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
August 8, 2013 at 9:13 am
GilaMonster (8/8/2013)
What version of SQL, what processor architecture, how many cores?
The DAC connection requires a sysadmin, not necessarily SA, so you should be able to use that to connect.
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
August 8, 2013 at 8:22 am
ChrisM@Work (8/8/2013)
Sounds like a Sisyphean task, similar to those given to raw recruits of some services - "Get me a Portuguese handpump and bring a bucket of steam with you".
and...
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
August 8, 2013 at 7:00 am
Viewing 15 posts - 12,151 through 12,165 (of 49,552 total)