Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Sybase
  2. Suggest New Category

How do you troubleshoot if your tempdb gets filled

Question Posted / guest

Answers were Sorted based on User's Feedback



How do you troubleshoot if your tempdb gets filled..

Answer / aditya

If the transaction log of tempdb is full then you call
login through sa and type following command.
> dump tran tempdb with trancate_only
> go

If the database is full then you can increase the size of
the database on a free device.
> alter database tempdb on device_name = size
> go

Is This Answer Correct ?    2 Yes 8 No

How do you troubleshoot if your tempdb gets filled..

Answer / prabhu

Do any of the following
1. restart the sybase database server
2. alter the size of the tempdb

Is This Answer Correct ?    13 Yes 24 No

How do you troubleshoot if your tempdb gets filled..

Answer / sri

use tempdb
go
sp_helpsegment "default"
go

Is This Answer Correct ?    11 Yes 25 No

Post New Answer

More Sybase Interview Questions

Why do my page locks not get escalated to a table lock after 200 locks?

0 Answers  

What is this tds protocol in sybase?

0 Answers  

How do I exclude a column in sybase?

0 Answers  

how to do application monitoring through AutoSys?

3 Answers   Cognizant,

What will happen if we create more indexes on a sysbase iq table?

1 Answers  

What is an advantage to using a stored procedure as opposed to passing an sql query from an application ?

0 Answers  

Differences between clustered and non-clustered in sybase?

0 Answers  

What is the difference in storage type of numeric and decimal data types in sybase ?

0 Answers  

Explain locking. List its types.

0 Answers  

What is a good example of a transaction in sybase?

0 Answers  

What is the default table size in sybase?

0 Answers  

How to delete unix files which are more than 3 days old?

0 Answers  

For more Sybase Interview Questions Click Here
Categories