Hey everyone. I have a server with a C:\ drive for the OS, and a D:\ drive for applications and data. It's running Windows Server 2008 R2.
Right now, we have a small pagefile on the C:\ drive and a larger one on the D:\ drive; this is how this server came set up by default. I did some monitoring over the last week, however, and found that the system is never even touching the pagefile - it has tons of RAM, and never even fills up 25%...
Skkra
Last Activity: Jan 15 '15, 05:43 PM
Joined: Oct 13 '11
Location:
-
How does Windows fill multiple pagefiles?
-
Can I safely disable VSS Writer?
I'm running SQL Server 2008 R2 Standard on several Windows Server 2008 machines. I perform my backups using SQL Server to save my BAK and TRN files to a dedicated backup drive.
Recently, we installed some 3rd party software on one of these servers that seems to be triggering VSS shadow copies for some reason. Every 2 hours, it's locking all databases for 4-5 minutes and no one can use them. Obviously, this is unacceptable.
... -
The problem ended up being on the Exchange side of things. Thanks for your response though! -
SQL Server mail won't alert my phone by text message
I'm trying to set up a system of alerts in SQL Server 2008 R2. Using Database Mail to email me works fine. However, I also want to receive a text message - I get dozens of after-hours emails a day, and if my phone buzzed for every one, I'd go insane. A text message will get my attention.
I have a Verizon iphone and can't seem to send myself texts through SQL Server. Querying the failed mail table (select * from msdb.dbo.sysmai l_faileditems)... -
SQL Server drive died, data drive is OK... now what?
We've just had a server go down. The operating system seems to be corrupted, so we'll likely need to reinstall everything on that drive.
The operating system and programs, including SQL Server, are on the C: drive.
The databases are all on the D: drive. D: seems OK. I've never run into this case. What happens now?
If we have to rebuild the C: drive and reinstall SQL Server, what state will the databases...
No activity results to display
Leave a comment: