TRACEYMARY
asked on
TEMPDB missing sp
After shrinking my tempdb that was 118 gig ...to 512 today its at 16 gigs...
Im looking at em on tempdb and look at sp...there are no sp there.
How to check why and put them back?
Im looking at em on tempdb and look at sp...there are no sp there.
How to check why and put them back?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Should i create a job to run each night to shrink the log and mdf of tempdb
Thanks
Thanks
ASKER
Oh ...i have the system sp......it just took 30 minutes to display them.........
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
So what the best thing i can do here...
How can i really determine what the temp db has or was doing ...and while it grewing like it is.....?
Should i write the script to shrink the mdf and ldf every night...?
(I know i should not have to..)
So the only way tempdb recreates itself is shut down (which is not an option).
Cheers
How can i really determine what the temp db has or was doing ...and while it grewing like it is.....?
Should i write the script to shrink the mdf and ldf every night...?
(I know i should not have to..)
So the only way tempdb recreates itself is shut down (which is not an option).
Cheers
ASKER
I believe the checkpoint is not working ..isn't the checkpoint supposed to clear the tempdb
>
>
ASKER
I mean there are no System SP there I look on another SQL and i see
db_checkinobject for example but not on SQL2
Im getting
The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space..
in all error logs but its not got no limit restrictions its on unlimited growth.
its the temp mdf thats grewing it was 1869 now its 16738 in a space of one day.