Database Down

Dear Expert,

We have Database in SQL server 2008 R2 having size approximately 490 GB,
after four and five hours our database down so that our website stopped, then we restart the Database server its again working then after some hours  again database down.
Kindly please let us know the reason so solve the problem.

Thanks in Advance
Asrar AzmiWeb DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ravi KamagondQA Test EngineerCommented:
Database maintenance can cause downtime if an operation is performed that needs to place a lock on a table for an extended period of time. Examples of such operations include:
1. Creating or rebuilding a non-clustered index (can prevent table modifications)
2. Creating, dropping, or rebuilding a clustered index (can prevent table reads and modifications)
3. Data center failure: This category of failures takes the entire data center offline, rendering any local redundant copies of the data useless. Examples include natural disasters, fire, power loss, or failed network connectivity.
4. Server failure: This category of failures takes the server hosting one or more SQL Server instances offline. Examples include failed power supply, failed CPU, failed memory, or operating system crashes.
5. I/O subsystem failure: This category of failures involves the hardware used to physically store the data and thus directly affects the data itself—usually causing data loss (which then may lead to downtime to perform disaster recovery). Examples include a drive failure, a RAID controller failure, or an I/O subsystem software bug causing corruption.
6.Human error: This category of failures involves someone (a DBA, a regular user, or an application programmer introducing an application software bug) making a mistake that damages data, usually causing data loss (and then potentially downtime to recover the data). Examples include dropping a table, deleting or updating data in a table without specifying a predicate, setting a database offline, or shutting down a SQL Server instance. Human errors are usually accidental, but they can also be malicious.

In all cases, data loss can be prevented and downtime can be minimized using the technologies in SQL Server 2008.
0
lcohanDatabase AnalystCommented:
What do you mean by "our database down"?
What are the Event Viewer messages/errors on the server where "our website stopped"?
What are the Event Viewer and SQL Log messages/errors on the SQL server where "our database down"?

Is this maybe a resources related issue on the SQL box like a disk full due to excessive T-log growth or maybe is running out of memory because the SQL Server does NOT have the MAX memory properly configured? Maybe CPU peaks due to missing indexes and the Performance Dashboard Missing Index report should help with that. http://blogs.msdn.com/b/tommills/archive/2008/05/30/performance-dashboard-missing-indexes-report.aspx


Did anyone managed to connect to the SQL Server were the database is and check its status? Check if there are any locks/blocks by running a command like SP_WHO2 in a SSMS query or look at the Activity Monitor?
0
Asrar AzmiWeb DeveloperAuthor Commented:
I received following message in EventViewer  

Autogrow of file 'gpssystem1_log' in database 'gpssystem' was cancelled by user or timed out after 32479 milliseconds.  Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.


Please check and reply soon
0
Anthony PerkinsCommented:
Your Auto grow is set to the default 10%.  It needs to be changed to a fixed size such as 500MB.  Let me know if you need more details.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.