Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
onionpunk
Starting Member
3 Posts |
 Posted - 2008-05-16 : 03:22:11
|
| Hi all,I'm very new with SQL Server. My company just purchased a dedicated server and we installed SQL Server 2005 Express Edition. The operating system is Windows Server 2003.We have only 8 databases in that machine and there is this 1 particular database that keeps getting error. I know that the database is in error if I go to the Management Studio Express and I expand the database, that particular database has no [+] expand symbol and if I try to view the properties it will say "out of memory error" or something like that.How can I find out what is causing this error? That database has is 18MB and is not used frequently. The error usually appears once every month.How to debug this issue?thanks in advance |
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2008-05-16 : 04:59:06
|
| For SQL Server 2005 Express Edition there is nothing to monitor the server or database,if possible better install Developer Edition and use the profiler to find the cause of the error.RKNAIR |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-17 : 18:17:38
|
| You can monitor the machine in perfmon. |
|
|
|
onionpunk
Starting Member
3 Posts |
Posted - 2008-05-21 : 22:20:20
|
| Thanks for the reply guys,I'll look into it more, I'm thinking of getting the Developer Edition |
|
|
|
|
|
|
How to monitor my SQL Server?