What is cmaxpktsz good for in Sybase
What is cmaxpktsz good for in Sybase?
Expert
cmaxpktsz the same to the parameter "maximum network packet size" that you can see by sp_configure. I advise only updating its value by sp_ configure. If several of your applications send or receive huge amounts of data across the network, such applications can achieve important performance improvement through using larger packet sizes. Two illustrations are large bulk copy operations and applications writing or reading large text or figure values. Generally, you want to keep the value of default network packet size small for users performing short queries, and allow users who send or receive large volumes of data to request larger packet sizes by setting the maximum network packet size configuration variable.
caddnetmem the same to the parameter "additional netmem" the same you can see by sp_ configure. Again, I advise only updating this value by sp_ configure. "Additional netmem" sets the maximum size of additional memory which can be used for network packets which are larger than ASE's default packet size. For additional netmem the default value is 0 that means that no extra space has been assigned for large packets. Noticed the discussion below, in maximum network packet size, for information on setting such configuration variable. Memory allocated along with additional netmem is added to the memory allocated by memory. This does not influence other ASE memory uses.
Give us a non-computer illustration of preemptive and also non-preemptive scheduling?
Whenever we are prepared to create a table in DBMS than what are the steps to follow?
Explain what is meant by the term universe stage?
Explain three types of SQL database server architecture?
Explain briefly the term an outer join?
Explain the term version Control?
Specify the types of prompt in the Cognos?
Describe the relationship of OLE DB, ADO, and ODBC?
Briefly explain the functional differentiations between COGNOs and BO?
Describe the three types of data sources which are used with ODBC?
18,76,764
1960778 Asked
3,689
Active Tutors
1415263
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!