here are my problem i have a slq sever ver 7.0 this server was installed with 150 concurrent conections but when i have 70 or less conections in some cases the server doesnt work like it have to do it the sql server begin to make so slow and the queries to the database are to slow or send me a message to me who says i cant conect to the server anyone knows what could be happen, the strage things its a have a script to kill the conectios and free it who have more than four minutes sleeping and anyway the server are to slow
and my poll of conections down to 20 or 30 after run this script but the problem continues.
my hardware is dual pentium III 800 mhz
512 in ram
2 scsi hard disks of 14 gb
O.S Windows nt 4.0
sql server 7.0
please help me
and my poll of conections down to 20 or 30 after run this script but the problem continues.
my hardware is dual pentium III 800 mhz
512 in ram
2 scsi hard disks of 14 gb
O.S Windows nt 4.0
sql server 7.0
please help me