Announcement

Collapse
No announcement yet.

Case 287

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Case 287

    Question:
    I am getting the following input from my SQL database: spid114,Unknown,Autogrow of file 'rms_log' in database 'rms' was cancelled by user or timed out after 8913 milliseconds. What does it mean?

    Possible Root Cause:
    1. This means that the database wants to enlarge, but it takes too much time to expand the database by the set size. The problem is probably that percent growth is set rather than absolute. If the database is already very large and should then grow by 10%, this may take too much time
    Solution:
    1. The SQL settings must be in absolute and not in percent:
    Click image for larger version

Name:	Case 287 print screen.png
Views:	366
Size:	50.8 KB
ID:	834

    Additional Information:
    Rotronic is no specialist in terms of SQL databases and is limited in terms of support.
Working...
X