PDM数据库优化调整——PDMSQL初始大小
发布时间：2022-02-14 信息来源： 浏览次数：
登录SQL
输入查询语句：
SELECT
SUBSTRING(a.FILENAME, 1, 1) Drive,
[FILE_SIZE_MB] = convert(decimal(12,2),
round(a.size/128.000,2)),
[SPACE_USED_MB] = convert(decimal(12,2),
round(fileproperty(a.name,'SpaceUsed')/128.000,2)),
[FREE_SPACE_MB] = convert(decimal(12,2),
round((a.size-fileproperty(a.name,'SpaceUsed'))/128.000,2)) ,
[FREE_SPACE_%] = convert(decimal(12,2),
(convert(decimal(12,2),round((a.size-fileproperty(a.name,'SpaceUsed'))/128.000,2))
/ convert(decimal(12,2),round(a.size/128.000,2)) * 100)),
a.NAME, a.FILENAME
FROM dbo.sysfiles a
ORDER BY Drive, [Name]
输入查询语句：
SELECT
SUBSTRING(a.FILENAME, 1, 1) Drive,
[FILE_SIZE_MB] = convert(decimal(12,2),
round(a.size/128.000,2)),
[SPACE_USED_MB] = convert(decimal(12,2),
round(fileproperty(a.name,'SpaceUsed')/128.000,2)),
[FREE_SPACE_MB] = convert(decimal(12,2),
round((a.size-fileproperty(a.name,'SpaceUsed'))/128.000,2)) ,
[FREE_SPACE_%] = convert(decimal(12,2),
(convert(decimal(12,2),round((a.size-fileproperty(a.name,'SpaceUsed'))/128.000,2))
/ convert(decimal(12,2),round(a.size/128.000,2)) * 100)),
a.NAME, a.FILENAME
FROM dbo.sysfiles a
ORDER BY Drive, [Name]
选择PDM库—》右键—》属性—》文件
更改款选值为24.19x1.2=29
生信科技为制造型业用户提供SolidWorks正版软件服务
形成以"定制方案+技术服务+成功实施"模式为制造业企业提供数字化设计、制造及管理解决方案，并为用户提供维护服务和技术支持