SQL Server 足迹
SQL Server 中的足迹是什么意思？
这是来自 MSDN 的片段“减少昂贵查询的锁占用空间”LINK
What does it mean by footprints in SQL Server?
here's a snippet from MSDN "reduce the lock footprint of expensive queries" LINK
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
在这种情况下，足迹意味着所制作的不同锁的数量。例如，锁越多，占用空间就越大。
The footprint in this case means the number of different locks being made. e.g. the more locks - the larger the footprint.
“足迹”并不专门与 SQL Server 相关，而是一个通用术语，指的是系统中受其他因素影响的部分。它与“生态足迹”或“碳足迹”等术语中使用的“足迹”相同。在这种情况下，就是说查询可以仅凭借运行来锁定其他表，这可以阻止其他查询访问相同的数据。因此，影响大量表的查询的“足迹”很大，并且会减慢系统速度。但是，如果您减少“占用空间”，使其影响不那么大，那么其他查询将可以自由运行并提高性能。
"Footprint" doesn't specifically relate to SQL Server, but is a general term referring to the parts of a system that are affected by something else. It's the same "footprint" as is used in terms like "ecological footprint" or "carbon footprint". In this case, it is saying that queries can lock other tables just by virtue of running, and this can block other queries from accessing the same data. Thus the "footprint" of a query that affects a lot of tables is large and will slow the system down. But if you reduce the "footprint" so that it doesn't affect so much, then other queries will be free to run and improve performance.
这意味着资源使用率会更低。在具体的例子中，无论他们谈论什么，都会使用更少的锁。这不是 sql server 的事情 - 您可以指减少内存占用的进程，或减少某些数据的存储占用。
It means that the resource usage will be lower. In the sepcific example, whatever they are talking about will use fewer locks. This is not a sql server thing - you could refer to a process reducing its memory footprint, or reducing the storage footprint of some data.
“足迹”通常是指对有限资源的某种使用。将其视为“对某物可用性的影响”。如果某项内存占用较大，则会影响可用内存量。如果某些东西减少了锁占用空间，则意味着它会影响所采用的锁的数量（在本例中是积极的）。
"Footprint" genereally refers to some sort of usage of limited resources. Think of it as "impact on the availability of something". If something has a large memory footprint, it affects the amount of free memory. If something reduces the lock footprint it means that it impacts the number of locks taken (positively, in this case).
“足迹”一词的使用是指查询锁定的数据量、锁的数量和类型的组合，一个表级锁比 10 个行级锁影响更多的数据。
减少锁足迹的方法包括
This use of the word footprint referes to the amount of data that is locked by your query, a combination of the number and type of locks, one table level lock effecting more data then 10 row level locks.
Ways of decreasing your lock foot print would include