DB 프로세스 문의 드립니다.
여***디
2016.11.02 13:23
조회 4620
※ 필수입력정보 ※
ms-sql 2008 R2 사용 중인데
.net 제품사용을 하지만 db에 sleep 되는 프로세스가 계속적으로 늘어나고 있습니다.
너무 많은 프로세스를 열고 있는데 Close 가 안되고 무한 열리는 이유는 무엇인지요?
| 53 | 커밋된 읽기 | 53 | 21:08.3 | SERVICE | Internet Information Services | 8384 | 4 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 54 | 커밋된 읽기 | 54 | 43:28.7 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 56 | 커밋된 읽기 | 56 | 58:37.4 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 59 | 커밋된 읽기 | 59 | 19:50.1 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 60 | 커밋된 읽기 | 60 | 56:34.0 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 62 | 커밋된 읽기 | 62 | 21:08.3 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 64 | 커밋된 읽기 | 64 | 05:19.8 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 67 | 커밋된 읽기 | 67 | 05:04.2 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 73 | 커밋된 읽기 | 73 | 52:17.9 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 75 | 커밋된 읽기 | 75 | 57:05.9 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 85 | 커밋된 읽기 | 85 | 21:06.7 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 86 | 커밋된 읽기 | 86 | 57:15.4 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 89 | 커밋된 읽기 | 89 | 43:45.6 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 90 | 커밋된 읽기 | 90 | 42:02.3 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 92 | 커밋된 읽기 | 92 | 56:47.7 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 95 | 커밋된 읽기 | 95 | 52:29.1 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 96 | 커밋된 읽기 | 96 | 05:11.3 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 97 | 커밋된 읽기 | 97 | 52:13.3 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 98 | 커밋된 읽기 | 98 | 53:39.6 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 99 | 커밋된 읽기 | 99 | 43:53.3 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 100 | 커밋된 읽기 | 100 | 05:14.7 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 102 | 커밋된 읽기 | 102 | 05:17.7 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 108 | 커밋된 읽기 | 108 | 05:22.0 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 109 | 커밋된 읽기 | 109 | 19:53.1 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 111 | 커밋된 읽기 | 111 | 21:07.8 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 113 | 커밋된 읽기 | 113 | 05:25.1 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x | ||
| 116 | 커밋된 읽기 | 116 | 21:08.3 | SERVICE | Internet Information Services | 8384 | 6 | OLEDB | 0x0BB034B687C924469A1F8D0E7A7D8AEC | nmail | sleeping | 0x |
▷ 제품버젼 :
▷ 오류발생 메뉴/주소 :
▷ 에러메세지 :
▷ 질문내용 :
댓글 1
| 이전 글 | 메일 수신이 전혀 안됨 2 | 삼******) | 2016.11.02 |
|---|---|---|---|
| 다음 글 | 외국 공격 차단 방법문의 드립니다. 1 | 여***디 | 2016.11.02 |