Designing a Scalable SQL Schema for Extensive Log Data

Data and Databases
1

I split a huge log table into server-specific tables for faster global queries.

CREATE TABLE LogX (msg NVARCHAR(MAX), ev INT, dt DATETIME); -- "Error",404,"2023-11-01"
2

hey, have u thought about time based partitions instead? it might be simpler than bunches of server tables, and range queries become fastr. also, tweak those indexes for better performance