October 28, 2008 at 1:40 pm
How to check how much database spased used on the server and how do I know if I need to increase size on my server?
October 28, 2008 at 2:02 pm
You can start with sp_spaceused. There are also several good dmv's
check out sys.dm_db_file_space_usage and sys.database_files.
DAB
October 28, 2008 at 3:45 pm
You need to track the usage of space over time to know if you need to add more space. In general you want enough space to last 2-6 months, so you don't have to manage it on an daily basis.
October 29, 2008 at 7:11 am
I don't know if I have enough space. Can you please help me. I have on my server:2147483647 in MB and my each db contains:
2048.75 MB
1491.56 MB
27.13 MB
125.00 MB
32.94 MB
10.00 MB
9.00 MB
57.31 MB
11.44 MB
3.94 MB
7297.31 MB
59.69 MB
3333.75 MB
58.69 MB
72.00 MB
92.06 MB
3209.50 MB
8316.44 MB
4.75 MB
1298.38 MB
14.50 MB
76.00 MB
87.81 MB
224.38 MB
10684.88 MB
81.31 MB
9249.44 MB
14719.19 MB
232.81 MB
77.88 MB
140.25 MB
18.31 MB
9.75 MB
7.50 MB
2924.00 MB
58.94 MB
122.13 MB
127.31 MB
60.94 MB
8.75 MB
1612.81 MB
101.00 MB
3687.38 MB
5152.75 MB
5205.44 MB
5183.69 MB
3000.00 MB
The server is very slow, we don't have any jobs running and no logs running and no error logs
October 29, 2008 at 7:34 am
Google may return a lot of results for what you want
To check disk space, you can run
EXEC master.dbo.xp_fixeddrives
Results
driveMB free
C121539
October 29, 2008 at 7:42 am
I check
C13018
E305935
What else it could be, My server is very slow,how can I check if there is any jobs are running against this server?
October 30, 2008 at 2:15 am
Have you the SQL Server DBA Dashboard installed? This will provide you with a lot of information about your server and your databases. You can find information about it here http://www.sql-server-performance.com/software/review/dba_dashboard_p1.aspx. Go to the last page of the article explaining the Dashboard and there is the link. Here the direct link to download it http://www.sqlserverexamples.com/v2/Products/tabid/76/Default.aspx.
About the speed of your server:
You have quite some databases on your system! Everything on one disk?
Do you have a lot of I/O operations? Check also the disk drives for fragmentation. If your hard disk is very fragmented it produces a lot of I/O when accessing the data. For sure there is others to check but this was the first came into my mind. Could it be the network which is slow and give the impression of a slow server?
Good luck.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply