| Author |
Message |
Marlon Brown
Guest
|
 Posted:
Tue Nov 01, 2005 9:51 pm Post subject:
How to delete records from MOM db via query ? |
|
|
My SQL grooming job fails. I launch it manually from Enterprise Manager and
it fails.
Going to the \MSSQL\Data folder, I observed that the SQL Onepoint db.mdf is
at 27GB. The db is set to 27GB maximum in Enterprise Manager.
How can I solve this ?
Should I attempt to delete "records" from the MOM db manually to make some
room for this SQL Onepoint db ? If so, please send me query I should use to
delete such records.
MOM2005SP1. |
|
| Back to top |
|
 |
Marlon Brown
Guest
|
| Posted:
Tue Nov 01, 2005 9:51 pm Post subject:
Re: How to delete records from MOM db via query ? |
|
|
Yes, partition for the SQL db is 90GB.
I have 35GB available free space, 55GB in use now. I don't see any
indication of lack of free disk space. No relevant errors in eventvwr
either.
Just the grooming job continues to fail.
"Blake Mengotto" <mengotto@nospam.hotmail.com> wrote in message
news:RLO9f.11710$tV6.3436@newssvr27.news.prodigy.net...
| Quote: | Is it failing because you are out of disk space? Do you have 40% free
space
in the onepoint db?
--
Regards,
Blake Mengotto
My Blog: http://spaces.msn.com/members/DiscussITnow/
Community Sites for MOM:
MOM Answers: http://www.momanswers.com
myITforum: http://www.myitforum.com
Momcommunity: http://www.momcommunity.com
Other Sites of Interest:
Silect Software: http://www.silect.com - MP Studio Express
eXc Software: http://www.excsoftware.com - MOM solution provider
Skywire Software: http://www.skiwiresoftware.com - MOM Connectors
"Marlon Brown" <nomail@brown.com> wrote in message
news:OyO%23bGx3FHA.2816@tk2msftngp13.phx.gbl...
My SQL grooming job fails. I launch it manually from Enterprise Manager
and
it fails.
Going to the \MSSQL\Data folder, I observed that the SQL Onepoint db.mdf
is
at 27GB. The db is set to 27GB maximum in Enterprise Manager.
How can I solve this ?
Should I attempt to delete "records" from the MOM db manually to make
some
room for this SQL Onepoint db ? If so, please send me query I should use
to
delete such records.
MOM2005SP1.
|
|
|
| Back to top |
|
|
Blake Mengotto
Guest
|
| Posted:
Tue Nov 01, 2005 9:51 pm Post subject:
Re: How to delete records from MOM db via query ? |
|
|
Is it failing because you are out of disk space? Do you have 40% free space
in the onepoint db?
--
Regards,
Blake Mengotto
My Blog: http://spaces.msn.com/members/DiscussITnow/
Community Sites for MOM:
MOM Answers: http://www.momanswers.com
myITforum: http://www.myitforum.com
Momcommunity: http://www.momcommunity.com
Other Sites of Interest:
Silect Software: http://www.silect.com - MP Studio Express
eXc Software: http://www.excsoftware.com - MOM solution provider
Skywire Software: http://www.skiwiresoftware.com - MOM Connectors
"Marlon Brown" <nomail@brown.com> wrote in message
news:OyO%23bGx3FHA.2816@tk2msftngp13.phx.gbl...
| Quote: | My SQL grooming job fails. I launch it manually from Enterprise Manager
and
it fails.
Going to the \MSSQL\Data folder, I observed that the SQL Onepoint db.mdf
is
at 27GB. The db is set to 27GB maximum in Enterprise Manager.
How can I solve this ?
Should I attempt to delete "records" from the MOM db manually to make some
room for this SQL Onepoint db ? If so, please send me query I should use
to
delete such records.
MOM2005SP1.
|
|
|
| Back to top |
|
|
Blake Mengotto
Guest
|
| Posted:
Wed Nov 02, 2005 1:51 am Post subject:
Re: How to delete records from MOM db via query ? |
|
|
I mean in your onepoint db. I assume you set it up to be a certain size,
then ensured it is not set to autogrow. So when you look at the db in SQL
Ent Manager you should be able to see how much space is used and what is
free, plus from the management server there is a perf counter that you can
bring up that will tell you the free space of your one point db. What value
is that?
If, when grooming starts, you don't have enough free space in the onepoint
db, then you may have to temporarly let your db autogrow, groom, then take
off autogrow.
--
Regards,
Blake Mengotto
My Blog: http://spaces.msn.com/members/DiscussITnow/
Community Sites for MOM:
MOM Answers: http://www.momanswers.com
myITforum: http://www.myitforum.com
Momcommunity: http://www.momcommunity.com
Other Sites of Interest:
Silect Software: http://www.silect.com - MP Studio Express
eXc Software: http://www.excsoftware.com - MOM solution provider
Skywire Software: http://www.skiwiresoftware.com - MOM Connectors
"Marlon Brown" <nomail@brown.com> wrote in message
news:%23yQ7TWy3FHA.3036@TK2MSFTNGP15.phx.gbl...
| Quote: | Yes, partition for the SQL db is 90GB.
I have 35GB available free space, 55GB in use now. I don't see any
indication of lack of free disk space. No relevant errors in eventvwr
either.
Just the grooming job continues to fail.
"Blake Mengotto" <mengotto@nospam.hotmail.com> wrote in message
news:RLO9f.11710$tV6.3436@newssvr27.news.prodigy.net...
Is it failing because you are out of disk space? Do you have 40% free
space
in the onepoint db?
--
Regards,
Blake Mengotto
My Blog: http://spaces.msn.com/members/DiscussITnow/
Community Sites for MOM:
MOM Answers: http://www.momanswers.com
myITforum: http://www.myitforum.com
Momcommunity: http://www.momcommunity.com
Other Sites of Interest:
Silect Software: http://www.silect.com - MP Studio Express
eXc Software: http://www.excsoftware.com - MOM solution provider
Skywire Software: http://www.skiwiresoftware.com - MOM Connectors
"Marlon Brown" <nomail@brown.com> wrote in message
news:OyO%23bGx3FHA.2816@tk2msftngp13.phx.gbl...
My SQL grooming job fails. I launch it manually from Enterprise Manager
and
it fails.
Going to the \MSSQL\Data folder, I observed that the SQL Onepoint
db.mdf
is
at 27GB. The db is set to 27GB maximum in Enterprise Manager.
How can I solve this ?
Should I attempt to delete "records" from the MOM db manually to make
some
room for this SQL Onepoint db ? If so, please send me query I should
use
to
delete such records.
MOM2005SP1.
|
|
|
| Back to top |
|
|
Marlon Brown
Guest
|
| Posted:
Wed Nov 02, 2005 9:51 pm Post subject:
Re: How to delete records from MOM db via query ? |
|
|
OK, I think that worked. Thanks !
Db size is now back to 15GB and grooming job ran OK last attempt.
"Blake Mengotto" <mengotto@nospam.hotmail.com> wrote in message
news:uyMHhsz3FHA.3292@tk2msftngp13.phx.gbl...
| Quote: | I mean in your onepoint db. I assume you set it up to be a certain size,
then ensured it is not set to autogrow. So when you look at the db in SQL
Ent Manager you should be able to see how much space is used and what is
free, plus from the management server there is a perf counter that you can
bring up that will tell you the free space of your one point db. What
value
is that?
If, when grooming starts, you don't have enough free space in the onepoint
db, then you may have to temporarly let your db autogrow, groom, then take
off autogrow.
--
Regards,
Blake Mengotto
My Blog: http://spaces.msn.com/members/DiscussITnow/
Community Sites for MOM:
MOM Answers: http://www.momanswers.com
myITforum: http://www.myitforum.com
Momcommunity: http://www.momcommunity.com
Other Sites of Interest:
Silect Software: http://www.silect.com - MP Studio Express
eXc Software: http://www.excsoftware.com - MOM solution provider
Skywire Software: http://www.skiwiresoftware.com - MOM Connectors
"Marlon Brown" <nomail@brown.com> wrote in message
news:%23yQ7TWy3FHA.3036@TK2MSFTNGP15.phx.gbl...
Yes, partition for the SQL db is 90GB.
I have 35GB available free space, 55GB in use now. I don't see any
indication of lack of free disk space. No relevant errors in eventvwr
either.
Just the grooming job continues to fail.
"Blake Mengotto" <mengotto@nospam.hotmail.com> wrote in message
news:RLO9f.11710$tV6.3436@newssvr27.news.prodigy.net...
Is it failing because you are out of disk space? Do you have 40% free
space
in the onepoint db?
--
Regards,
Blake Mengotto
My Blog: http://spaces.msn.com/members/DiscussITnow/
Community Sites for MOM:
MOM Answers: http://www.momanswers.com
myITforum: http://www.myitforum.com
Momcommunity: http://www.momcommunity.com
Other Sites of Interest:
Silect Software: http://www.silect.com - MP Studio Express
eXc Software: http://www.excsoftware.com - MOM solution provider
Skywire Software: http://www.skiwiresoftware.com - MOM Connectors
"Marlon Brown" <nomail@brown.com> wrote in message
news:OyO%23bGx3FHA.2816@tk2msftngp13.phx.gbl...
My SQL grooming job fails. I launch it manually from Enterprise
Manager
and
it fails.
Going to the \MSSQL\Data folder, I observed that the SQL Onepoint
db.mdf
is
at 27GB. The db is set to 27GB maximum in Enterprise Manager.
How can I solve this ?
Should I attempt to delete "records" from the MOM db manually to make
some
room for this SQL Onepoint db ? If so, please send me query I should
use
to
delete such records.
MOM2005SP1.
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in