To start off, I am a Software Engineer - nowhere near a DBA. I can install SQL Server and setup a simple SQL Server database, which I have done. I setup a simple SQL Server 2016 database on a client's web server (Windows 2012 R2) to store some data for a new website being deployed on the server. It started off as a very small database with a few tables. It has quickly grown to have a few dozen tables, several of which have thousands of records. The database is basically being used to import data from an external API and store it locally so that it can be accessed frequently without performance issues. All of the data imports are up an running without issue. However, I have noticed CPU spikes on SQL Server. More importantly, the log file for the database is up to 33GB. I am very afraid this log file is going to end up using all of the available disk space and crash the server. I need to know what I can do in the short-term (until we get a real DBA in here) to prevent this from happening.
Subscribe to:
Post Comments (Atom)
linux - How to SSH to ec2 instance in VPC private subnet via NAT server
I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...
-
I did some reaches, and I know "Desktop.ini" and "Thumbs.db" files are hidden files for view customizations, and I know ...
-
I am trying to understand why the OOM killer has reaped a process on a KVM virtual machine running with 1 gigabyte of memory. While I do alr...
-
I have a HP DL380p Gen8 server with ESXi 5.5 running on it and HP Smart Array P420i. I've installed 4 new hard disks on it and want to p...
-
I have (only) 512MB to spare. The only thing running on my VPS is PHP/MySQL and on top of it Wordpress. No mail server or any other applicat...
-
On RabbitMQ 3.5.7 Ubuntu 16.04. I want to implement RabbitMq Management plugin only on localhost, the idea is to use a tunnel to reach the R...
-
We rolled out this new Windows 8.1 machine on the domain recently, other desktops are still using XP. One of the software we install is the ...
-
What software would you recommend to monitor a network? We have a main server which acts as a DNS among other services. An...
No comments:
Post a Comment